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 (116)
RE: Dynamic Date Slicer (improve relative date slicer)
For my current project, I am asked to split a calendar year into two parts in order to create a Fiscal Year Report. The FYE date changes from one client account to the next. Split #0 covers the period from 1 January 2020 to the FYE20 date, while Split #1 covers the period from the FYE20 date to 31 December 2020, and Split #2 covers the period from 1 January 2021 to the FYE21 date. Then Split #2 would be appended to Split #1 for the actual report. I have set the default FYE dates to 31 December. How would I use an FYE column or measure to dynamically set the slicer?
RE: Dynamic Date Slicer (improve relative date slicer)
Is there any update for implementing this feature? It's been outstanding since 2017 with the original idea created in 2016...
RE: Dynamic Date Slicer (improve relative date slicer)
Would this provide the ability to filter n periods before and n periods after the current date ?
Today = 24th March 2021, so filter covering from
set dates , e.g. 1st January 2021 thru to 30th June 2021
or 3 months before and 3 months after
RE: Dynamic Date Slicer (improve relative date slicer)
This needs This Period / PTD (PERIOD to date) to be useful in many businesses!
RE: Dynamic Date Slicer (improve relative date slicer)
Please improve time zone issue with update since everything defaults to UTC. This renders the entire feature useless if the data needs to be shown in a specific time zone. For example, selecting "In This..." doesn't work as expected as it pulls in information not according to my company's day.
RE: Dynamic Date Slicer (improve relative date slicer)
Please add true YTD and MTD options for relative date!! We are having to spend too much time writing long DAX statements to get around the standard 'this year' or 'this month' options.
RE: Dynamic Date Slicer (improve relative date slicer)
Need more functionality for period to date. Businesses like to use 2 fiscal years plus the current FYTD. This is not possible with the current date slicer.
RE: Dynamic Date Slicer (improve relative date slicer)
It will be fantastic if "This" refers to the last date selected by the user on a slicer, not the system date.
RE: Dynamic Date Slicer (improve relative date slicer)
Is the new version planned with a date to select?
RE: Dynamic Date Slicer (improve relative date slicer)
If we add one more feature to Relative Date Slicer, then it would pretty much remove most of the dimension model relative month/year/week offset field. Most of the times we look at reports from 3 months past to 3 months forward. Without relative month/week/year offset integer field we are not able to do that with current Related Date Slicer. It would be great to have this feature added so that we can all together eliminate unnecssary so many offset fields we have to use in each of those reports.