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]

Hi Will, it would be nice if the slicer could accommodate fiscal year slicing.

[neil_tavares]

In addition to "Last" "1" "Days" it would be great to have the option to select the "most recent" date in the database. I have the situation where my data auto refreshes, but when that doesn't work, I would like to display the most recently fetched data based on the fetch date. Using Last 1 Days shows today's date's data, which then gives no results if the automatic refresh did not occur.

[AmirReza]

Before going ahead with this idea, I think it is important to add a slicer format for TimeOfDay. I find it very puzzling why a slicer for date has been implemented for so long but to filter your reports by hours/minutes/seconds of a day is still not available.

[mahadevan]

how to scroll the year values in the date range slicer

[Mill1234]

The planned fix won't satisfy all requirements. Agree it should be dynamic, but you should be able to set a range...i.e. Relative date is based on data or a set time/date, then show prior 3 month and future 9 months or similar. As data is updated each month, the charts will dynamically shift to show the next window of time.

[jkinney]

Should add a function in the relative date slicer to have a non continuous date range like comparing months/quarters on a YoY basis

[ismael_texidor]

Is there a way to start from the first of the month when selecting "Last" in the relative date slicer instead of the same day as today? Example: Today is SEP 16, 2018 Selection = "Last 1 Year" Desired output = Dates start from "Sep 1, 2017" instead of "Sep 16, 2017".

[ageraci1]

Need to be able to change the start of the week to any start date.

[fbcideas_migusr]

Please allow the option for the end-user to also select an anchor date. We have use cases where user might want to see performance of 2 prior quarters to say Mar 31st ... if the date filter is of relative type - there is no way the end-use can do that. Besides adding YTD/MTD, etc. please also let the end-user select the anchor date (just as a report author can right now).

[chris_puncher]

Can you also add support for fiscal date slicing? This is pretty fundamental in the corporate world.