Forum Discussion
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 of an SSAS cube, my date fields no longer behave the same, it stays like a simple list filter.
Is this enhancement of date slicers compatible with data from an SSAS cube?
Regards.
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
9 Replies
v-qiuyu-msftCommunity Support
Hi cubadrum,
It seems that you connect to the SSAS cube in Import mode, and place the date field in a slicer. The slicer only provide List and Dropdown modes, right?
Based on my test, the issue is caused by that date field is converted to TEXT data type automatically when connecting to SSAS cube in import mode. We need to change it to Date data type then Between, Before, After modes will be available in the slicer.
Best Regards,
Qiuyun YuHello v-qiuyu-msft,
Thanks for the reply!!
I forgot to comment that I use the "Connect Live" option to connect to the cube. Using this option I see that the options to modify the data type are disabled.
In the cube, the field is set as a date, but in Power BI desktop, it does not take this configuration.Regards.
- v-qiuyu-msft
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.
