Skip to main content

Power BI

Planned

Dynamic Date Slicer (improve relative date slicer)

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

Andy Wilbourn on 05 Jul 2020 22:56:30

RE: Dynamic Date Slicer (improve relative date slicer)

The time calculations should also include accounting calendars like 4-4-5 and not assume a calendar year calendar. It would seem that common accounting calendars should be set in the tool and we choose the one we need based on our accounting implementation. Having things built within the tool has a higher chance it will work efficiently as there are a lot of smart people who work on the project. We find our calculations that we created seem to work, but feel slow.

's profile image Profile Picture

John S on 05 Jul 2020 22:56:10

RE: Dynamic Date Slicer (improve relative date slicer)

Any "YTD/MTD" is of marginal usefulness unless the START date can actually be set. Is that Fiscal YTD, Calendar YTD, or School Year YTD??

MTD is not as much need, although some folks DO set the start of their Fiscal Month other than the First. Just not very common.

's profile image Profile Picture

Daníel Hjörvar on 05 Jul 2020 22:56:00

RE: Dynamic Date Slicer (improve relative date slicer)

Kinda clumsy but the relevant date slicer shows Next 1 Days = Last 1 Days which clearly doesn't make any sense.

Hope this gets fixed

's profile image Profile Picture

Hannes Wall on 05 Jul 2020 22:55:55

RE: Dynamic Date Slicer (improve relative date slicer)

You should also be able to select start day of the week. Currently it defaults to Sunday with no way of changing it.

's profile image Profile Picture

Victor Franco on 05 Jul 2020 22:54:22

RE: Dynamic Date Slicer (improve relative date slicer)

The relative date filter released in july is great, but it is missing the "Quarter" option, that seems to be so easy... Hope it appears in the next update.

's profile image Profile Picture

Lucas on 05 Jul 2020 22:54:07

RE: Dynamic Date Slicer (improve relative date slicer)

Would be great a date picker like Google Analytics or this awesome webapp https://demo.baremetrics.com/. The new date slicer is far away from that. It's not User Friendly at all.

's profile image Profile Picture

victor on 05 Jul 2020 22:53:33

RE: Dynamic Date Slicer (improve relative date slicer)

In MS Excel I can create a date slicer and select for example '2016-april' (or whatever). After that, with cube functions, I create a date range from that date ('2016-april') till one year before ('2015-may' in this case). It works pretty nice, but I can not do that in Power BI. Can we add this? It will become a possibility soon?

's profile image Profile Picture

Nelson Fraser on 05 Jul 2020 22:53:24

RE: Dynamic Date Slicer (improve relative date slicer)

One of the additional items that needs to be included in the relative date slicer is "older than" or "before".
The ability to show all items created "before 2 weeks ago" would be very handy

's profile image Profile Picture

Stretcharm on 05 Jul 2020 22:53:07

RE: Dynamic Date Slicer (improve relative date slicer)

the last x days including today is fixed in july release. Plus great relative time filters. Thanks

's profile image Profile Picture

Stretcharm on 05 Jul 2020 22:53:02

RE: Dynamic Date Slicer (improve relative date slicer)

Nice feature. I have an issue with Include today option not working with Last x days. It works fine with weeks and months,