on 08 Nov 2016 19:48:12
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.
Administrator on 11 May 2017 06:28:15
We just shipped a preview of the new relative date slicer in the May release of Power BI Desktop. Learn more about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/
- Comments (47)
RE: Dynamic date slicer
Please add the "Latest" option to have the slicer show latest available date
RE: Dynamic date slicer
Good idea. I think, we need Last12month also.
RE: Dynamic date slicer
Is it possible to add customized date ranges for fiscal quarters and fiscal years?
RE: Dynamic date slicer
Yea this is pretty easy to do on your own with a mapping table
RE: Dynamic date slicer
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.
RE: Dynamic date slicer
that would be very cool.
RE: Dynamic date slicer
'@ 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.
RE: Dynamic date slicer
This is easily achievable with custom report date attributes. For example, add a column to your date table named ReportMonth. When processing your date table always make ReportMonth equal to MonthName, except for the current month which has a value of "Current". Then save your reports with "Current" in the ReportMonth filter. Every time you refresh your report will be pointing to the current month.
You can use this same method for other types of reporting periods.
RE: Dynamic date slicer
This would be great, especially if automated report exports are rolled out.
RE: Dynamic date slicer
PLEASE make this happen!!