Skip to main content
Microsoft Idea

Power BI

Completed

Better Date Range filters

Vote (997) Share
Peter Eliason's profile image

Peter Eliason on 12 Apr 2016 22:42:26

The timeline slicer (Custom Visualization) functions, but it is not a friendly tool. If I quickly want to select a "Start" and "End" date for a date range, it would be more helpful to have a popup calendar with an optional freeform text box for both the "Start" and "End" date ranges.

Administrator on 01 Nov 2016 05:05:24

I'm very pleased to say we've shipped a much improved date slicer in the October release of PBI Desktop. More details are available here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/#reportView Let us know what you think and please keep those suggestions coming! thanks!

Comments (70)
Peter Eliason's profile image Profile Picture

Power BI User on 05 Jul 2020 22:19:38

RE: Better Date Range filters

Also, an option for Yesterday would be very useful.

Peter Eliason's profile image Profile Picture

Louie Lin on 05 Jul 2020 22:19:35

RE: Better Date Range filters

When something can be filtered by date, an option for “Today” would be very useful.

Peter Eliason's profile image Profile Picture

Power BI User on 05 Jul 2020 22:19:21

RE: Better Date Range filters

Do this and do it soon.

Peter Eliason's profile image Profile Picture

Devin Harrington on 05 Jul 2020 22:19:17

RE: Better Date Range filters

adding votes for this!

Peter Eliason's profile image Profile Picture

Dave Schmidt on 05 Jul 2020 22:18:12

RE: Better Date Range filters

I couldn't agree more with the need for this. Many sites allow filtering by a to and from date (using a calendar that you just pick from). Quite frankly, the timeline slicer is clunky and not actually very usable. A date from and date to filter/slicer would work far better. Please Power BI team ... make this one happen!!!

Peter Eliason's profile image Profile Picture

David Cresp on 05 Jul 2020 22:16:37

RE: Better Date Range filters

I was surprised that this was not included. You can do it in Excel why not Power BI

Peter Eliason's profile image Profile Picture

Pflipper on 05 Jul 2020 22:12:15

RE: Better Date Range filters

There's been a call for a time slicer, and that's been incorporated into the PowerBI tool. This request for improvement is for a slider, or some kind of toggle that allows a viewer of the report to move back or forward by a specific time period (year/quarter/month/day) by clicking a button of moving a slider.

Peter Eliason's profile image Profile Picture

Pflipper on 05 Jul 2020 22:12:13

RE: Better Date Range filters

Incorporate a date slider or incrementor

Peter Eliason's profile image Profile Picture

Power BI User on 05 Jul 2020 22:09:11

RE: Better Date Range filters

Instead of filtering using fixed dates also filtering on last x days/months/years. The reporting window will automatically adapt to the progression in time.

Peter Eliason's profile image Profile Picture

Power BI User on 05 Jul 2020 22:02:57

RE: Better Date Range filters

It would be great to have To and From date picker functionality as Out of Box as business reports may want to view sales info between to dates.