Skip to main content

Power BI

Planned

Dynamic Date Slicer (improve relative date slicer)

Vote (1753) 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 (89)
's profile image Profile Picture

4ee0d66b 12da-4df9-b625-d0d461235d7a on 05 Jul 2020 23:07:07

RE: Dynamic Date Slicer (improve relative date slicer)

I would also like an option to choose dates more than one month ago (X days/months). Some of our transactions "expire" after a certain time, meaning that their status should have changed after a month. Filtering the data to show a certain status with more than one month since the status change would be very helpful.

's profile image Profile Picture

6e46bb55 f32a-4464-ad9d-eca3ec846fec on 05 Jul 2020 23:06:59

RE: Dynamic Date Slicer (improve relative date slicer)

Would it be possible to set multiple time frame views on one chart, for example when we have 4 years history plus details of current year (I. E. 2013 - 2017) show 2013, 2014, 2015, 2016 as single years and the months of 2017 -Jan, Feb, Mar, ..., Nov-?
I believe it would be great.
It works perfect with excel pivot tables
Thank you

's profile image Profile Picture

5ff148c5 dfec-4ef1-a13f-646a92c4c567 on 05 Jul 2020 23:06:01

RE: Dynamic Date Slicer (improve relative date slicer)

I have found the relative date is missing the option to state "Is In the Last and Current" "X #" "Calendar Months". If I select "Is in the last" "X #" "Months" it includes the current month activity which I want but it also shows a partial month for the first month listed for those remaining days in the current month. If I select "Calendar Month" instead of "Month" I do not see current month activity. The typical use for this is a column chart where the user wants to see the last 12 months including the current month as one of the 12 months but the other 11 should be complete months and the user can see the current month building as we work through the month. Maybe I am missing something to make this work as is.

's profile image Profile Picture

b06af199 d781-41c5-9dd4-9e024354d132 on 05 Jul 2020 23:05:54

RE: Dynamic Date Slicer (improve relative date slicer)

Can you add an option for YTD + x calender years? Would be awesome!

's profile image Profile Picture

15edc63c 64a0-418a-8b78-92bc4937edb7 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

af63e415 533c-481a-bf90-053ac0fb4a79 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

af63e415 533c-481a-bf90-053ac0fb4a79 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

9559389a 82cd-464c-b644-0a8da6fdea8c 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

4cecc129 9542-4244-ada5-1701afedb0cf on 05 Jul 2020 23:01:24

RE: Dynamic Date Slicer (improve relative date slicer)

Please allow for setting a fiscal year