Forum Discussion
Timeline Slicer
Right - well the timeline slicer in Excel 2013 onwards works perfectly we loads of data sources - I really want to like Power BI and want to use it within my company but its very hard to promote something when things don't seem to work right.
Yeah the timeline slicer isn't the best. Instead put your date field out there and instead of the timeline slicer, just use the regular slicer. You'll need to format your date field into another column of however you want to show the date, i.e. Jun 2015, etc. For that example you would use the Month,Year dax function. This will show all the dates/years you have in that field.
It didn't even seem to work with a stored procedure where the date format is 'yyyy-MM-dd', even in a slicer it just gave the year which is bizarre behaviour.
It has just worked with the MD and tabular version of Adventureworks but the point is, if the excel timeslice filter works correctly how come this one doesn't - you can't expect companies to go and change things like this to fit this - they should just work as expected.