The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a table with a column showing percentages, on this column I have set up conditional formatting with rules seen below. Values showing as 100% are not following the set rules correctly. Showing up as amber instead of green as they should.
I have set the rules up as numbers and 100% is represented as 1 as I have had issues with the previously. However I cannot find a fix for this situation.
Anyhelp greatly appreciated, thank you.
Solved! Go to Solution.
@DataLicious you have 2 condition with <= 1. Check that out.
for yello it should be >= 0.85 < .99999
for green it should be >= .99999 <=1
@DataLicious you have 2 condition with <= 1. Check that out.
for yello it should be >= 0.85 < .99999
for green it should be >= .99999 <=1
Thankyou for the second pair of eyes!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
76 | |
65 | |
52 | |
51 |
User | Count |
---|---|
127 | |
116 | |
78 | |
64 | |
63 |