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 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/
Scott A commented
This still needs work. If date hierarchy includes TIME, then we should be able to slice by that as well for more granular slicing. (HOUR/MINUTES)
I'd be thrilled if we could have YTD.
For those saying it is easy to do this by adding data to the report model - only true if you are pulling your data into Power BI. This is not possible if you are connecting to SSAS MD.
I simply want more advanced date filtering or even the possibility to write a formula for a report level filter when hitting SSAS MD.
I don't think this can be set as completed. There is a lot of work to do. For example:
- Select a single day with a calendar picker.
- When you are using relative dates and select weeks, they always start on Sunday, you can't choose if wou want weeks to start on Monday
Randy Evans commented
The new date slicer is a nice improvement. What would also be great is the ability to select previous time slices like this: 1 week ago, 2 weeks ago, 3 weeks ago; or 1 month ago, 2 months ago, 3 months ago, etc. With this option, one can look at a current time period range (e.g., week, month, year, etc.) and then easily compare it to a past (or future) time period of the same range.
Adam Kruzel commented
I agree with Marc that something in preview should NOT be marked Complete. I would think it's in preview so we can test it out and if there's nothing wrong, comes out of preview. Once out of preview, then mark Complete.
I also not only agree with sdjensen that the release doesn't match his request, but being able to just click on YTD, QTD, MTD, Rolling 12 months is much needed by the business and this release doesn't address that. This release gives nice flexibility, but still requires more clicking around for the user to get what they need.
I'd simply mention that preview features shouldn't be marked as complete as they are subject to change - often without warning or explanation.
Case in point : export to pbix.
I strongly disagree that the released feature matches my idea. I can't make any of my wanted selections of time with the new feature.
We have a problem with the weeks (our weeks run from Monday till Sunday) and the relative dateslicer selects Sunday until Saturday. It would be nice if that can be set also.
Can you also add hour?
Is this coming in the May 2017 update?
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!