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

[jprice3]

Could we please have an additional option for This/Next/Last Quarter?

[KCantor1]

On the Before option can we have Before "Today" and maybe make the slicer stackable? For example date is between 01/01/2018 and "Today" or This year before "today".

[astephens]

I haven't read all the comments so this may have been discussed, but I have also really appreciated the relative date option. I would however love an enhancement, which should be simple, to allow the negative of the statement as well. Not in the xxxx. I.e. I want to exclude all new products in my analysis. So not with a date first sold in the last 3 months.

[wildmight]

Good morning, May I suggest bringing out the anchor date functionality to the filter of the visual? Instead of visualizations - where it's only available for advanced user. Or making it so that a variable can be used to set the anchor date - which would also be ideal. Thank you! Great job!

[paula_virmasalo]

Having two different date slicers in one report is a bad idea. So. Could it be possible to add the possibility to choose date range manually in dynamic date slicer? Dynamic date slicer is good for keeping the report "refreshed", but sometimes we want to explore the data with specific date range.

[Rebecca]

Completely agree the dynamic Date filtering needs improving. Its so close to what we need yet so far! Enabling the AND & OR option in"Relative Date filtering" like there is for 'Advanced Filtering' would be another way to provide more flexibility to help achieve more dynamic filtering options. E.g. in "The last 6 Calendar Months" AND in "This Calendar Month". "In the last 2 months" AND "In this month" AND "In the next 2 Months"

[fbcideas_migusr]

I'd love the relative date filter to allow me to specify Is Before Today Minus 60 days. Or even "Is NOT This Month"

[r_scott_hunt]

Please add Quarter To Date

[josh_flory1]

Please allow us to use DAX in the properties to specify our begin and end dates. Also, please allow the user to click on a relative date slicer and specify their OWN begin and end dates. Currently if we use a relative date slicer and the user decides they need to view the data with a different begin and end date...that is not possible. If we show last 6 months and the user decides they really want to see a 9 month window, but starting 3 months ago, that is not possible. They can't just click the filter and pick 1/1/2017 through 9/1/2017. They would have to key in last 24 months or similar to move back that far and they would have far more data displayed than desired (which throws off averages, etc..)

[nuno_carneiro]

Any update on when this will be completed?