Skip to main content

Power BI

Planned

Dynamic Date Slicer (improve relative date slicer)

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

Daniel Geboltsberger on 12 Sep 2024 10:42:42

RE: Dynamic Date Slicer (improve relative date slicer)

Please add dynamic filtering also to be handed over to dashboards.eg: if dynamic filter of last 5 month is set on visual and pinned to a dashboard, this 5 days are converted to static filter :(

's profile image Profile Picture

Austin Bristow on 15 Aug 2024 15:32:51

RE: Dynamic Date Slicer (improve relative date slicer)

Apologies if this is already in the 112 comments, but being able to select 'In the Last n period' AND 'in the next n periods' to create a dynamic rolling window would be a great way to see recent results + upcoming forecasts/plans/etc in an automated way

's profile image Profile Picture

Victor Yamaykin on 01 Aug 2024 15:07:36

RE: Dynamic Date Slicer (improve relative date slicer)

Make sure to include a way to set the time zone for the relative date filter. This time zone should by default correspond to the one where the report is being viewed. Remember to include logic to handle daylight saving time in that area.

's profile image Profile Picture

Andy Clapham on 02 Jul 2024 10:18:32

RE: Dynamic Date Slicer (improve relative date slicer)

 James Bartlett on 22 Aug 2022 21:11:44 ReportRE: Dynamic Date Slicer (improve relative date slicer)BEFORE YOU VOTE: Have you tried using the Preselected Slicer visual?That slicer is great, it's very close to what we're looking for here for date slicers.I wonder if the publisher has any plans to extend the selection options to date ranges?

's profile image Profile Picture

Collin Tsui on 29 Sep 2023 19:53:19

RE: Dynamic Date Slicer (improve relative date slicer)

Please include ability to set relative dates on both ends of the range (e.g. from 90 days ago to 90 days from now), as opposed to being limited to the current date as one end of the range. Thank you!

's profile image Profile Picture

Matt Finlay on 01 Sep 2023 09:56:39

RE: Dynamic Date Slicer (improve relative date slicer)

Please ensure this functionality allows a fully dynamic start/end date selection.For example, in my organisation we have reports that want default dates to be:last complete Mon - Sun weeklast complete Sat - Fri weeklast complete monthyear to yesterday (01/04 start)year to last month end (01/04 start)rolling 28 days to yesterdaybut (crucially) still allow uses to select any date range outside of these (but still limited by the dates in the data).

's profile image Profile Picture

Poul Jorgensen on 17 Jun 2023 15:41:14

RE: Dynamic Date Slicer (improve relative date slicer)

Addtionally:Please include an option not to include today. Last 3 weeks is no including todayPlease implement the ability to state when a week ends. Calendar weeks is ruined if you can not specify week start day. Not all countries use Sunday as start of week

's profile image Profile Picture

David Zebrowitz on 06 Dec 2022 17:30:45

RE: Dynamic Date Slicer (improve relative date slicer)

Option to set TimeZone rather than having it built on UTC!

's profile image Profile Picture

James Bartlett on 22 Aug 2022 21:11:44

RE: Dynamic Date Slicer (improve relative date slicer)

BEFORE YOU VOTE: Have you tried using the Preselected Slicer visual?

's profile image Profile Picture

Laurence S on 11 Aug 2022 21:04:08

RE: Dynamic Date Slicer (improve relative date slicer)

Any word when this is coming? Would be great to be able to set the default dates in a "between" date slicer with dax but allow them to be edited by the report viewer.