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 Thanks for your fast responses. Is this the method you are suggesting? I also created a duplicate measure that removes the sumx funtion by using the selected value within the Switch function as seen below.
SWITCH(
SELECTEDVALUE(MeasuresIdentication[ID]);
1; FORMAT(sumx([Measure1]);"0,0%");
2; FORMAT(sumx([Measure2]);"###.###);
...;...;
99; FORMAT(sumx([Measure99]);"###.### $")
)SWITCH(
SELECTEDVALUE(MeasuresIdentication[ID]);
1; FORMAT(sumx([Measure1]);"0,0%");
2; FORMAT(sumx([Measure2]);"###.###);
...;...;
99; FORMAT(sumx([Measure99]);"###.### $")
)
VERSUS
SUMX(TABLE,
SWITCH(TABLE[ID]),
Hi jignaski18 ,
Yes that is the way I'm suggesting, as refered if you place a format function inside the SUMX the values will get error since you are trying to make a sum of text values.