Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to 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
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
OOS = 0% Green
0% < OOS ≤ 1% Orange
OOS > 1% Red
Please try this , If it is work kindly accept the solution
Please try this
OOS = 0% Green
0% < OOS ≤ 1% Orange
OOS > 1% Red
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
67 | |
61 | |
46 | |
45 |