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
Accepted answer is for Tabular SSAS models as multidimensional SSAS models do not make use of Power BI date filtering.