Forum Discussion
Matrix Row Conditional Color Formatting - Field Value
Hi all,
I am trying to apply conditional formatting to a measure inside of a Matrix "ROW" but my color measure doesn't work.
Any tip on why it doesn't work?
Conditional Formatting Measure:
Status_Color IF =
IF (
[My % Measure] > 1.15 || [My % Measure] < 0.85, //Greater than 115% or Less than 85%
"RED",
IF (
[My % Measure] >= 0.90 || [My % Measure] <= 1.1, //Greater or equal to 90% or Less or equal to 110%
"GREEN",
IF (
[My % Measure] >= 0.85 && [My % Measure] < 0.90 || //Greater or equal to 85% or Less than 90%
[My % Measure] > 1.1 && [My % Measure] <= 1.5, //Greater than 110% or Less or equal to 115%
"YELLOW"
)))
88% should be Yellow
112% should be Yellow
Thanks,
Alex
6 Replies
Please try the following:
SWITCH(TRUE(),[My % Measure] < 0.85 || [My % Measure]> 1.15 ,"RED",
[My % Measure] >= 0.90 || [My % Measure] <= 1.1,"GREEN",
([My % Measure] >= 0.85 && [My % Measure] < 0.90) || ([My % Measure] > 1.1 && [My % Measure] <= 1.5),
"YELLOW"
)Hi Padycosmos,
thank you very much for your reply but nothing changed it shows the same as with IF 😞I have moved up the yellow. Could you please see if it makes a difference?
SWITCH(TRUE(),[My % Measure] < 0.85 || [My % Measure]> 1.15 ,"RED",
([My % Measure] >= 0.85 && [My % Measure] < 0.90) || ([My % Measure] > 1.1 && [My % Measure] <= 1.5), "YELLOW",
[My % Measure] >= 0.90 || [My % Measure] <= 1.1,"GREEN")
