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.
Very important feature! Really difficult to believe it wasn't there already.
+1 to Matt's comment ... Timeline navigator view from Datazen needs to be incorporated into PowerBI !
Double Amen to previous comment. We need this feature.
Glenn Burnside commented
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).
Pedro Innecco commented
Fantastic idea. Extremely important!
Agreed. Date is key. timeline slicers seem to be the most user friendly version of presenting this data
John Fitzpatrick commented
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.
Scott Kadler commented
This is the last and most important piece for my team to completely switch over to Power BI from Excel dashboards.
Matt English commented
Amen to previous comment. Date dimension is critical - get the Datazen and Power BI teams in a room together!
When drilling down to dates, I have witnessed that the filters are released automatically when drilling. For instance, if I make a bar chart of years and drill down into months, the filter of the years get released. The dashboard then displays the details of the months for all years, and not for that particular year from which it was drilled down. I think this is a very important feature that needs to be looked at.
Steve Thomas @stephendthomas commented
Slicing similar to pivot would be awesome.
The timeline slicer is definitely an extremely helpful addition. It would be great to use the timeline slicer based on SSAS Tabular Date dimensions. Currently, the information somehow gets lost and date dimensions are taken as "flat" dimensions.
David yang commented
Date range filter is also very helpful
Stuart Potter commented
agree - a timeline slicer option would be extremely useful ... I was looking for such a thing just now, in fact
Phil Gad commented
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.
Fernando Rodriguez commented
For the Finance and Accounting world, having the ability to handle dates, will be a huge improvement to BI.
Vlad Kosarev commented
This is actually a very strange omission. Would love to have date range element for everything.
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.