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 (112)
RE: Dynamic Date Slicer (improve relative date slicer)
Thanks
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!
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 week
last complete Sat - Fri week
last complete month
year to yesterday (01/04 start)
year to last month end (01/04 start)
rolling 28 days to yesterday
but (crucially) still allow uses to select any date range outside of these (but still limited by the dates in the data).
RE: Dynamic Date Slicer (improve relative date slicer)
Addtionally:
- Please include an option not to include today. Last 3 weeks is no including today
- Please 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
RE: Dynamic Date Slicer (improve relative date slicer)
Option to set TimeZone rather than having it built on UTC!
RE: Dynamic Date Slicer (improve relative date slicer)
BEFORE YOU VOTE: Have you tried using the Preselected Slicer visual?
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.
RE: Dynamic Date Slicer (improve relative date slicer)
This should allow for non-standard periods, as business may choose to use their own business week, say Friday to Thursday, or or a custom 28-day period with the occasional 35-day period as a true-up.
There should also be a filter option to remove all future date values, or all past date values, from the slicer and put highest (or lowest) time period at the top of the list, as the default view. One would be useful for historical data visuals and the other for projected data visuals.
RE: Dynamic Date Slicer (improve relative date slicer)
How about implementing YTD, ATD as per country wise Financial Year. using totalytd doesnt make sense in India as the FY starts from April.