cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## 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 6
Solution Sage

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

Resolver I

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

Solution Sage

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

Resolver I

Solution Sage

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

Resolver I

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors