Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Conditional Formatting using SSAS Multidimensional as a Live Data Source

Hi all,

 

I am currently encountering a problem where conditional formatting does not seem to work.

 

Data source: SSAS 2016 Multidimensional cube

Connection type: Live (direct)

Power BI Desktop (Aug 2018 version)

 

Basically, I want to make negative values to have red coloured font, and postive values to have green font using table visual.

When I go to Conditional Formatting > Font Color, I choose "Format By" = Rules and set the conditions, but it does not work.

The colour did not change.

 

Is this a limitation of using SSAS MD Live connection?

Any ideas how I can make the conditional formatting work in this case?

 

Thanks

 

 

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I dont plan to create a new measure, but using the fields from the cube directly and want to format the font color, but it does not seem to work either.

       

      Limitation or I just dont know how to do it..

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        >>I dont plan to create a new measure, but using the fields from the cube directly and want to format the font color, but it does not seem to work either.

        In fact, I can setup conditional formatting on existed fields from SSAS live connection datasource. 

         

        Regards,

        Xiaoxin Sheng