Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

pbiideas1

Dynamic date slicer

Submitted by on ‎11-08-2016 11:48 AM
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.
Status: Completed
See more ideas labeled with:
49 Comments (49 New)
Comments
juan10
New Member
‎07-05-2020 03:43 PM
Can someone please tel me when will the numeric slicer be available for publishing?
amschlitt
New Member
‎07-05-2020 03:43 PM
Great news! Be sure last month is available as well as this month.
jon53
New Member
‎07-05-2020 03:43 PM
Thanks Alex!
jpoudou
New Member
‎07-05-2020 03:45 PM
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...
Afer
Advocate I
Advocate I
‎07-05-2020 03:45 PM
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.
MuratAksakal
Regular Visitor
‎07-05-2020 03:45 PM
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.
maik1
New Member
‎07-05-2020 03:47 PM
Can you also add hour?
mark_gulati2
New Member
‎07-05-2020 03:47 PM
Is this coming in the May 2017 update?
TheCakeSurgeon
New Member
‎07-05-2020 03:48 PM
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.
fbcideas_migusr
New Member
‎07-05-2020 03:48 PM
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.