Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Timeline Slicer (For date, month, quarter, year)

Ability to have date/month/quarter/year slicer automatically created from date field (just like what Excel does with Timeline slicer) would be really good.
Status: Completed
Comments
dten
New Member
Not a better date slicer but actually a set of Date controls so you will be able to select a date range visually, popup a calendar or analyze by seasons and holidays. As someone mentioned in a book that I don't remember right now: In dimensional modeling, the Date dimension is the most important dimension of them all.
vlad_kosarev
New Member
This is actually a very strange omission. Would love to have date range element for everything.
fbcideas_migusr
New Member
For the Finance and Accounting world, having the ability to handle dates, will be a huge improvement to BI.
stuart9
New Member
agree - a timeline slicer option would be extremely useful ... I was looking for such a thing just now, in fact
philgad
New Member
Why restrict the use of sliders to the date fields? It should be possible to map range sliders on any column containing continuous numeric values. For example sliders mapped to the columns of disconnected tables would allow the creation of "what if analysis" dashboards, with a very elegant way.
bworley
New Member
Agreed. Date is key. timeline slicers seem to be the most user friendly version of presenting this data
steve_thomas
New Member
Slicing similar to pivot would be awesome.
john83
New Member
I agree that this would be something quite useful. However I'd like to see it implemented a bit differently than the Excel timeline slicer in 2013 or the date functions included in PowerQuery. The defaults in these are good for standard calendar based analysis, but any kind of fiscal calendar doesn't work well with them. I'd like to have a configurable timeline filter with adjustable/defineable periods.
glenn4
New Member
This is so critical I can't believe it's been left out up to this point - so much analysis is about drilling in to specific date ranges, and doing relative comparisons (this period vs. previous period).
SKadler
New Member
This is the last and most important piece for my team to completely switch over to Power BI from Excel dashboards.