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
This would definitely be a good addition to the slicer
RE: Dynamic date slicer
Last Month as well please
RE: Dynamic date slicer
also TTM (Trailing Twelve Months) and similar common "trailing" periods
RE: Dynamic date slicer
Amuses me that BI reports are consistently built with From and To date prompts even when the report is titled something like "xxx Monthly Report". 99.9% of the time users always put in the first of the month to the last day of the month, and run the report at 9am on the ?th day of the subsequent month.
Relative date filters make life a lot easier for everyone. I would add previous periods to the list of options.
RE: Dynamic date slicer
I agree. Last 30 days could be also useful.
RE: Dynamic date slicer
I agree
RE: Dynamic date slicer
Additionally, dynamic dates based on the data would be great too. For instance: most recent day of data