Forum Discussion

cubadrum's avatar
cubadrum
New Member
9 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

cubadrum's avatar
cubadrum
New Member
9 years ago

Hello 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's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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