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

Jason Locke on 05 Jul 2020 22:25:00

RE: Better Date Range filters

This slicer would be great it is sized better into a smaller form and also if the Y, Q, M, D, etc.. selector at top left stayed on screen at all times and did not require having to scroll back.

Peter Eliason's profile image Profile Picture

Santiago Galvis on 05 Jul 2020 22:24:48

RE: Better Date Range filters

Is there an estimated completion date for better date range filters? Thank you!

Peter Eliason's profile image Profile Picture

Rozack on 05 Jul 2020 22:24:27

RE: Better Date Range filters

I am not atall happy with the current timeline slicer. Time being a major factor for analysis its really sad how the current timeline works.

It just takes up lot of space and looks quite ordinary as compared to the other components.

Peter Eliason's profile image Profile Picture

Игорь Стерхов on 05 Jul 2020 22:23:47

RE: Better Date Range filters

Also it would be interesting to have such fuctionality not only in report slicers, but also in query date parameters.

Peter Eliason's profile image Profile Picture

Gabriel Siqueira on 05 Jul 2020 22:23:43

RE: Better Date Range filters

The timeline slicer is a pretty neat feature. I really like how it works. Now, my problem is that it's clunky, taking up too much space and not resizing properly.

Peter Eliason's profile image Profile Picture

Seshu Hakuju on 05 Jul 2020 22:23:32

RE: Better Date Range filters

I would like the slider in compact size.

Peter Eliason's profile image Profile Picture

MikeD on 05 Jul 2020 22:23:24

RE: Better Date Range filters

I would like to suggest that the timeline slicer (or any other calendar control that might be in development) support custom fields defined for custom calendar periods. For example, I believe the current options only allow for Year, Quarter, Month, and Day. If you have fields in your date table defining custom periods (ex. Period 1 - 2016, Period 2 - 2016, or whatever), it would be useful to be able to add those to the timeline slicer and remove the options you don't need.

Peter Eliason's profile image Profile Picture

Barry on 05 Jul 2020 22:23:09

RE: Better Date Range filters

Yes! Please add today, month, tomorrow, and options for "rolling time frames" today - 7, etc. Excel has tooday, now, etc. Power BI should be able to as well. Love the product. Keep the updates coming!

Peter Eliason's profile image Profile Picture

Chris on 05 Jul 2020 22:22:39

RE: Better Date Range filters

The filter box should allow for some sort of Date () or Now () functions as well that we can work with.

Peter Eliason's profile image Profile Picture

Игорь Стерхов on 05 Jul 2020 22:22:04

RE: Better Date Range filters

Please add this, yes.
Also need Last "X" day /weeks/month/quarter/years from Today filter !

voted.