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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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 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

      • cubadrum's avatar
        cubadrum
        New Member
        9 years ago

        Awesome v-qiuyu-msft
        This resolved my problem. Thanks.