Dynamic date slicer
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.
We are working on this… stay tuned!
I think it should not limited on the date. on the dashboard we can get easly every selected slicer value to use the any calculation filter the data set, espacialy runing average values based on the slicer values.
This would be a very good feature. As has been mentioned by others - especially in conjunction with automated reports, where eg. previous month is always selected. Make this as dynamic as possible - so you can select whatever date range you want dynamically. As an example with an Excel like formula like EOMONTH(date,-1) which would select the last date of the previous month.
please, support for retail and fiscal calendars (and any custom calendar)!!!!! lunar calendar is just 1 type of calendar...
all the retail industry is using retail calendar, all financial guys are using fiscal calendars, all the education is using school calendars...
Can someone please tel me when will the numeric slicer be available for publishing?
Dan Day commented
That's great news Alex. Is there any change you can make it have dynamic financial year starts? for instance as it is now the P BI Qtr 1 is our Qtr 4 and it confuses our end users. It would be great if I could have a financial year option where I could set the start month. Something similar would also be good for weeks as we do not have live data and always work a day behind so for us I would like our WTD to be a day out of sync so it would be good if I could also change the WTD range to incorporate this. Hope that all makes sense
Andrea Scharris commented
Great news! Be sure last month is available as well as this month.
Lars Kemmann commented
We need shorter time intervals too -- last X years/months/weeks/days/hours/minutes/seconds -- the short intervals become essential for push datasets with Azure Stream Analytics, and there are a number of feedback requests on this site that are all some variant of that basic need!
4, 12, 24, 52 weeks please!
Enrico A. Discacciati commented
I like it when are we getting this?
jon bell commented
although I have a date table created on our servers this would enable me to more quickly analyse our data. however consideration should be given for a start and end date for the year. we mostly report using UK fiscal years (1st Apr - 31 Mar) and our quarters are also in that format. most of the automatic time aggregation options I have seen only work with calendar years. a solution similar to TOTALYTD where you can specify the year end date would be essential.
Dan Meier commented
This will be a HUGE asset for non-IT end-users who are unable to make changes to the source data's table structure.
Dan Day commented
thanks for letting us know Kim. I would be happy for you to implement a feature that stops us using 'workarounds', as you have done with the current date slicer
Power BI team,
Please don't waste your time on this. The requested feature is easily achievable through a proper constructions on a dimensional date table
Amanda Doughty commented
@kim Any ETA?
Excellent! Can't wait!
Michael Shparber commented
Good news it is planned!
I would like to point out that it should be supported by Dashboard also, not just by the Report.
So, when I pin, say, Last Date, sliced visual to Dashboard, it should always dynamically show the data for the last date.
I think it is important, since the objects in Dashboard behave differently from report once pinned
Quoted from below
"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"
This is a great way to work around this limitation in the model and is a common practice. I would hate to see the Power BI team waste valuable time on this request when there are many other requests which have no work around, like being able to use a measure in the Min and max of conditional formatting, or beig able to rename attributes and measures for connected models, or being able to resize the text of a KPI!
Please add the "Latest" option to have the slicer show latest available date
Good idea. I think, we need Last12month also.