conditional formatting on column for background color by rules

[azeenk]

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

[Ritaf1983 · Accepted solution]

HI @azeenk 
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

[pankajnamekar25]

OOS = 0% Green
0% < OOS ≤ 1% Orange
OOS > 1% Red

Please try this , If it is work kindly accept the solution

[pankajnamekar25]

Please try this 

OOS = 0% Green
0% < OOS ≤ 1% Orange
OOS > 1% Red