Conditional Formatting based on text for live connection

[daniw]

Hi all, please help me...

I have live connection to cube and I need to set conditional formatting based on text. I have already found tutorials how to do conditional formatting via Measure with DAX formula "SELECTEDVALUE" (see below), but this formula is not available for live connection mode. Do you have any idea?

Measure Value = 
var 
   MySelection = SELECTEDVALUE('Measures 1'[MEASURE ID])
return
   SWITCH(
       TRUE();
          MySelection = 1;FORMAT([VALUE SHARE];"0.0%");
          MySelection = 2;FORMAT([VALUE SHARE DYA];"0.0%");
          MySelection = 3;FORMAT([VALUE SALES IYA];"0");
          MySelection = 4;FORMAT([VOLUME SALES IYA];"0");
          MySelection = 5;FORMAT([$/SU IYA];"0");
          BLANK()
          )

 Thank you in advance!

[v-chuncz-msft · Accepted solution]

@daniw 

You can't create 'report level' measures when authoring a report that is connected live to an SSAS multidimensional model. The only measures that are available are those defined in the MD model.

• Considerations and Limitations
• https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when...