Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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")
If the data is not sensitive , could you please share the pbix file?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |