Dynamic Date Slicer (improve relative date slicer)

[pbiideas1]

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

[fbcideas_migusr]

I would also like an option to choose dates more than one month ago (X days/months). Some of our transactions "expire" after a certain time, meaning that their status should have changed after a month. Filtering the data to show a certain status with more than one month since the status change would be very helpful.

[cmalzkron]

Any update here? The last one is 6 months old ...

[fbcideas_migusr]

Where is this? Been in preview since June??

[clercc]

The addition of Quarter is important and has been lacking.

[fbcideas_migusr]

Need a pre-defined slice for Yesterday, and possible some way to exclude today. Last ... 1 ... Days gets you today. To me, today is day 0, and last 1 day would be yesterday. To get to Yesterday I have to select Last ... 2 ... Days, but that INCLUDES today. Need a way to slice for Weeks as well. Maybe choices for "Calendar Week (Sun. start)" and "Calendar Week (Mon start)"

[pbiideas1]

Using the relative date filter is nice, however it's not really useful until you present the option for the end user to alter the reference date. For example: If I set the relative date filter to "Last 1 Days" and turn "Include today" Off in the Format pane I expect to get the figures for Yesterday. However If I would like to see the figures for another historical day, I am unable to do so without changing to another kind of date slicer, and that is not possible if I'm only a report consumer not working in PBI Desktop.

[salaminf1]

Quarter is definitely needed. Quarter is mandatory for our analysis !

[fbcideas_migusr]

New slicer is awesome, it handles many scenarios, but not everything, unfortunately. When it is saved in "relative" mode (preferable for us), user can't change it back to "between", so cannot select "3 months ago", "2 years ago" etc. I don't think it is possible to cover all required "relative periods", so would be great to give users an option to switch it back to "between" mode.

[jasperaubel]

Can you please include an option to indicate the start day of weeks as well? Currently in the slicer, the weeks are always starting on Sundays. But according to the ISO standard, weeks start on Mondays.

[c_ramirez]

Filtering by Quarter is definitely needed feature. If we could also include the ability to exclude relative dates that would be great.