Forum Discussion
conditional formatting on column for background color by rules
Hello Team,
I have applied conditional formatting by rules for the background color of the spce column in Power BI. The rules I used are:
Green for 0%
Orange for 0% < OOS ≤ 1%
Red for OOS > 1%
However, I noticed that some values that should be highlighted in orange are incorrectly appearing as red instead. Could you please help me troubleshoot this issue?
Looking forward to your guidance.
Thnaks,
Hk007
HI Anonymous
Replace the condition from percent to number and use decimal numbers like
0.01
Or use DAX like
OOS_Color =
SWITCH(
TRUE(),
[OOS] = 0, "Green",
[OOS] <= 0.01, "Orange",
[OOS] > 0.01, "Red"
)If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- pankajnamekar25
Super User
Please try this
OOS = 0% Green
0% < OOS ≤ 1% Orange
OOS > 1% Red - pankajnamekar25
OOS = 0% Green
0% < OOS ≤ 1% Orange
OOS > 1% RedPlease try this , If it is work kindly accept the solution
- Ritaf1983
HI Anonymous
Replace the condition from percent to number and use decimal numbers like
0.01
Or use DAX like
OOS_Color =
SWITCH(
TRUE(),
[OOS] = 0, "Green",
[OOS] <= 0.01, "Orange",
[OOS] > 0.01, "Red"
)If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
