Skip to main content

Power BI

Planned

Dynamic Date Slicer (improve relative date slicer)

Vote (2756) Share
's profile image

on 18 May 2017 19:35:34

This is a repost of my idea that was closed as completed, but the 'relative date slicer doesn't allow any of the described request hence my idea is not implemented....

The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved report makes sense - especially as the report gets older.

Dynamic options could be
YTD, QTD, MTD, WTD, Today, This Year, This Quarter, This Month, This Week and so on.

original idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17004565-dynamic-date-slicer

Administrator on 16 Jun 2017 23:57:11

The relative date slicer (a Preview feature as of June '17) gets us close to this with the 'This Month' or 'This Year' settings. That is a dynamic date selection that updates based on the current system date. We plan to add a 'YTD'/'MTD' option to specifically select a range from the start of the month/year up to today, hopefully that'll address the remaining requirements!

Comments (115)
's profile image Profile Picture

Helena on 05 Jul 2020 22:52:24

RE: Dynamic Date Slicer (improve relative date slicer)

I agree that being able to specify the start date of a year is important, not everyone has a financial year that starts 1 January.

's profile image Profile Picture

duc thai on 05 Jul 2020 22:52:03

RE: Dynamic Date Slicer (improve relative date slicer)

we need a couple text box at run time so user can type in what they like to pull in for the report not thing that have to pre define in a table or query
currently there is no way to pull in data for example for a column with text filed between a range with wild card cpt4 code from a* to cd* etc , there are hundred or thousand of diagnose in a diagnose table the end user is not going to select a drop down and click many of them just to select what to get into the report , they should able to type in 2 text box and get what they want.
these are very basic input parameter and every bi software have it , even access data has it
but is not avaible for power bi desktop

's profile image Profile Picture

Dan Day on 05 Jul 2020 22:51:47

RE: Dynamic Date Slicer (improve relative date slicer)

We need to be able to set when the YTD starts as our YTD is from 1st April not 1st Jan, so it will be a useless feature for us.

's profile image Profile Picture

David on 05 Jul 2020 22:51:30

RE: Dynamic Date Slicer (improve relative date slicer)

This also needs to have native logic to recognize/support a previously set or defined fiscal year, in addition to the calendar year.

's profile image Profile Picture

Matt Kowalski on 05 Jul 2020 22:49:53

RE: Dynamic Date Slicer (improve relative date slicer)

We need this ASAP! Especially for those of us connecting live to SSAS MD. Our options in Power BI are massively limited compared to those importing their data or using tabular. Having these filtering options will solve a lot of our pain points.