Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
azeenk
Frequent Visitor

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%

  • azeenk_3-1742881842821.jpeg

     

    azeenk_2-1742881832166.png

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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
pankajnamekar25
Memorable Member
Memorable Member

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

 

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

pankajnamekar25
Memorable Member
Memorable Member

Please try this 

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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