Forum Discussion
Solved
Date slicer filter doesn't work with dates from SSAS Cube?
Hello, I worked on a report with Excel as a data source, my time filters became a cool Date Slicers filters. (I guess because it is modeled with Date format). But when I work with the perspective o...
Hi cubadrum,
When we retrieve data from the keyColumns, it use the NameColumn data type actually. In your scenario, I would suggest you set the data type for the ValueColumn as Date type. Then place Date.value field in the slicer visual.
Best Regards,
Qiuyun Yu
Does anybody have a solution to this?
I cant see the .value columns, is this some hidden setting when doing a live connection to SSAS?
Any other workarounds?
Regards
Jon
So it turns out it wont display the value property if its part of a hierarchy.
Once I turned on hieararchy to visible for the date key, it popped up with the value.
Mystery solved.
This worked for me! Thanks!