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.

[rfaley]

This would be great, especially if automated report exports are rolled out.

[beneuto1]

'@ previous commenter - your solution would not be helpful when querying from large datasets. Trying that against something like Azure DocumentDB with billions of documents would prove to be a slow, very expensive experience. Date is a common way to filter large historical datasets to more manageable size. Date is a universally recognised and well defined construct and therefore a good candidate for standard functionality.

[fbcideas_migusr]

Add to the options listed in the original post Previous YTD, Previous Year QTD etc so we can have a comparison side by side of the the current year vs last year same period without having to mess around doing custom report date attributes etc.

[jmcconville1]

Yea this is pretty easy to do on your own with a mapping table

[konstantinidis]

that would be very cool.

[hxy0135]

Good idea. I think, we need Last12month also.

[Laura_Connolly1]

Is it possible to add customized date ranges for fiscal quarters and fiscal years?

[myrt_ramon]

Please add the "Latest" option to have the slicer show latest available date

[heathernicole]

Excellent! Can't wait!

[rlansing1]

4, 12, 24, 52 weeks please!