Forum Discussion

daniw's avatar
daniw
New Member
7 years ago
Solved

Conditional Formatting based on text for live connection

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!