Forum Discussion
Solved
Data Manipulation for Matrix Table
I need some help with formatting my data in order to organize my matrix table correctly. I have searched the web for 2-3 days now trying multiple methods but with no luck on a solution. I have tried ...
Hi jignaski18 ,
You also need to add the selection of the measure as in the previous formula should be:
Conditional Formatting= SWITCH(TRUE(); SELECTEDVALUE(Table[MeasureName]) = 1 && [Measure1] >0 ; "#FFFFFF"; SELECTEDVALUE(Table[MeasureName]) = 1 && [Measure1] <0 ; "#000000"; ...;...; SELECTEDVALUE(Table[MeasureName]) = 99 && [Measure99] > 0 ; "#123456"; SELECTEDVALUE(Table[MeasureName]) = 99 && [Measure99] < 0 ; "#999999" )Should work as expected, sorry for misleading you.
MFelix This Solution worked. Measure Name in Column, Values in values, then conditional formatting for values (backround) selected value Conditional Formatting(measure).
Values =
SWITCH( SELECTEDVALUE(Table[MeasureName]),
1,Measure 1,
2,Measure 2,
...,...,..,
etc. etc.)
Conditional Formatting=
SWITCH(TRUE();
SELECTEDVALUE(Table[MeasureName]) = 1 && [Measure1] >0 ; "GOLD";
SELECTEDVALUE(Table[MeasureName]) = 1 && [Measure1] <0 ; "RED";
...;...;
SELECTEDVALUE(Table[MeasureName]) = 99 && [Measure99] > 0 ; "GOLD";
SELECTEDVALUE(Table[MeasureName]) = 99 && [Measure99] < 0 ; "RED"
)
Glad I could assist.
Please mark the correct answer so that others can be helped.