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
Anonymous
Not applicable

Conditional Formatting Not Working with Percentage > 100

I am trying to set a rule on a measure if the value is greater than 100% to turn the background color to green. 

It its a legitimate number going greater than 100% but I am getting an Logic error.

Can this be fixed /any workaround. Kindly suggest. 

VijethaDivakara_1-1691444099155.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Don't use 'Percent' in the drop down, use > 1 'Number' and < 1000 'Number'

The Percent option does not have anything to do with acual percentage values.  It looks the the percentag of the total dataset that falls into the range.

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Don't use 'Percent' in the drop down, use > 1 'Number' and < 1000 'Number'

The Percent option does not have anything to do with acual percentage values.  It looks the the percentag of the total dataset that falls into the range.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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