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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
alj554
Regular Visitor

Conditional Formatting Not Working on Correct Number Range

Hi,

 

I am trying to create a calculated column with these conditional formatting rules, but the colors appear to be off by one range (ie the numbers in the 80s are in green instead of yellow, 70s are yellow instead of red). I am not getting any errors for the column and the numbers are correct, so was just wondering why the colors are off. Also worth noting, I used this same set up for two other columns and did not have issues with the colored backgrounds. conditional formatting rulesconditional formatting rulesoutcomeoutcome

3 REPLIES 3
Anonymous
Not applicable

Hi @alj554 ,

 

Try use number:

0.9, 1

0.8, 0.9

0, 0.8

 

 

FreemanZ
Super User
Super User

try choose Percent for all condition. 

Did this and it automatically converts to minimum and maximum with "number" instead of percent. Was not an issue for other columns that I did this on so not sure why it is not working

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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.