Skip to main content

Power BI

Planned

Dynamic Date Slicer (improve relative date slicer)

Vote (2753) 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

Scott A on 05 Jul 2020 23:04:49

RE: Dynamic Date Slicer (improve relative date slicer)

Last X hours!!! We need TIME, not just days/months/years.

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:02:18

RE: Dynamic Date Slicer (improve relative date slicer)

Would be ideal if we could just code our own defaults in DAX ;)

's profile image Profile Picture

Caroline on 05 Jul 2020 23:01:47

RE: Dynamic Date Slicer (improve relative date slicer)

Could we adapt when a week start? Today by default this is Sunday. Here a week starts on Monday!

's profile image Profile Picture

Caroline on 05 Jul 2020 23:01:47

RE: Dynamic Date Slicer (improve relative date slicer)

Could we have a relative format on Week Nr and Month Nr? This will allow us to select automatically the same WeekNr or MonthNr no matter is the year.

's profile image Profile Picture

Tom on 05 Jul 2020 23:01:44

RE: Dynamic Date Slicer (improve relative date slicer)

'Please pay attention to this. I can't understand how Power BI can be developed so rapidly but something so basic can be ignored. Just add every feature you can possibly think of, allow us to turn on/off the features we need and we'll be happy!

- Select one or more months/years/quarters
[2017] [2016]
[Q1] [Q2]
[AUG] [SEPT]

- Have the current month, year, or quarter displayed by deafault without having to see "this" "calendar year"

- Just more options in general. Our users want to explore our data via a range of dates, being able to select "last/this/next 1 day" is all well and good, but why isn't it easy to select all of august 2016 without entering text for example

's profile image Profile Picture

Dominic Locas on 05 Jul 2020 23:01:24

RE: Dynamic Date Slicer (improve relative date slicer)

Please allow for setting a fiscal year

's profile image Profile Picture

Mads Berge-Lind on 05 Jul 2020 23:01:09

RE: Dynamic Date Slicer (improve relative date slicer)

It would be great to be able to set a range that is dynamic for both start and end, e.g. +/- 3 months, +3 to +18 months, etc.

's profile image Profile Picture

Roel Dijkstra on 05 Jul 2020 23:00:38

RE: Dynamic Date Slicer (improve relative date slicer)

I wouldn't mind a simple Yesterday in the relative date slicer.

's profile image Profile Picture

Jack Wells on 05 Jul 2020 23:00:23

RE: Dynamic Date Slicer (improve relative date slicer)

Can we have the ability to select the baseline for YTD/QTD etc. A lot of companies don't start their financial year in January.

's profile image Profile Picture

Andrew on 05 Jul 2020 22:59:52

RE: Dynamic Date Slicer (improve relative date slicer)

Is there any current ability to have BI filter automatically by "Recent 12 Weeks" without having to change the filter every time like this post mentions with the need for dynamic date selection?

If not, I would certainly like to see this type of option rolled into the need for a Dynamic Date Slicer. To select Recent Weeks or Months that may not fall into the normal ranges like MTD.

This would basically run like selecting "Last Week" through "-12 weeks from this week". Anything in that manner would be huge for my reporting.