Matrix Row Conditional Color Formatting - Field Value

[adelmonte]

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

[Padycosmos]

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"
)

[adelmonte]

Hi @Padycosmos, 
thank you very much for your reply but nothing changed it shows the same as with IF 😞

[Padycosmos]

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")

[adelmonte]

@Padycosmos  unfortunately it doesn't work

[Padycosmos]

If the data is not sensitive , could you please share the pbix file? 

[adelmonte]

@Padycosmos   data is sensitive I can't share it thanks anyway