Forum Discussion
daniw
7 years agoNew Member
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!
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.
1 Reply
- v-chuncz-msftCommunity Support
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.