Dynamic date slicer

[pbiideas1]

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.

[SonjaN]

We have a problem with the weeks (our weeks run from Monday till Sunday) and the relative dateslicer selects Sunday until Saturday. It would be nice if that can be set also.

[revans2]

The new date slicer is a nice improvement. What would also be great is the ability to select previous time slices like this: 1 week ago, 2 weeks ago, 3 weeks ago; or 1 month ago, 2 months ago, 3 months ago, etc. With this option, one can look at a current time period range (e.g., week, month, year, etc.) and then easily compare it to a past (or future) time period of the same range.

[saket_sharan1]

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19217986-please-allow-clear-selections-in-slicer-when-hea

[pbiideas1]

'I don't think this can be set as completed. There is a lot of work to do. For example: - Select a single day with a calendar picker. - When you are using relative dates and select weeks, they always start on Sunday, you can't choose if wou want weeks to start on Monday

[mkowalski]

I'd be thrilled if we could have YTD. For those saying it is easy to do this by adding data to the report model - only true if you are pulling your data into Power BI. This is not possible if you are connecting to SSAS MD. I simply want more advanced date filtering or even the possibility to write a formula for a report level filter when hitting SSAS MD.

[scott_allison]

This still needs work. If date hierarchy includes TIME, then we should be able to slice by that as well for more granular slicing. (HOUR/MINUTES)

[lode_devos]

YTD is not available, so this is not completed

[vladimir_janovs]

QTD or YTD are still missing