Forum Discussion
Timeline Slicer
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.