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

[KellyDittmar]

While working thru this - is there a reason the date slicer does not include an option for a single day? There is a between option - and before and after options - but not an "On Date" option. This would be exceedingly helpful to my reporting at this moment.

[Gillian_Watson]

Would be very useful to have a relative date filter where it is Plus AND Minus a certain time period around todays date. Ie from 2 weeks ago to 2 weeks time.

[pierrewessman]

Would be an awesome addon, nearly all reports Im developing would benefit from this.

[drickusa1]

Currently we run Snapshots on our data and we need the ability to have the relative date slicer to default to the last date snapshot date that is available.

[afoulk4]

Is there any current ability to have BI filter automatically by "Recent 12 Weeks" without having to change the filter every time like this post mentions with the need for dynamic date selection? If not, I would certainly like to see this type of option rolled into the need for a Dynamic Date Slicer. To select Recent Weeks or Months that may not fall into the normal ranges like MTD. This would basically run like selecting "Last Week" through "-12 weeks from this week". Anything in that manner would be huge for my reporting.

[alexandre_tanne]

To do YTD. Use two relative time visual filters. First one relative filters 'this year' (ex: jan-dec 2017). Then a second second filter that filters the relative previous 12 months (September 2016-September 2017). The intersection is YTD January 2017-September 2017.

[chayanupadhyay1]

Relative slicer which can only provide option for Future days, as of now it gives the functionality for Last and This as well as it gives the option to Select Days, Weeks etc. But if it restricts to select only future days. I already logged question for the same, if there is any solution to achieve this then please do reply. PFB the URL: http://community.powerbi.com/t5/Desktop/Slicer-with-the-option-to-select-Next-Days-wrt-to-current-date/m-p/253744

[jackhwells]

Can we have the ability to select the baseline for YTD/QTD etc. A lot of companies don't start their financial year in January.

[roeldijkstra]

I wouldn't mind a simple Yesterday in the relative date slicer.

[dlocas]

Please allow for setting a fiscal year