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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi @v-qiuyu-MSFT,

 

I have changed the basic setting Type attribute to Calendar->Date.

Also, i have set key column to Int, Name column to WChar and Value column to Date datatypes.

I am still unable to see any additional measure 'with an extension ".Value" in power Bi desktop.

 

The things that i have tried so far are:

1. Changing Name fields format to yyyy-MM-dd.

2. Including Value field as date. 

3. Changing Value field's format to yyyy-MM-dd.

4. Removing Name column and just retaining key and value columns.

 

None of these seem to work on my SSAS multidimensional cube.

 

 Regards,

Chetan A.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      This worked for me! Thanks!