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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
madmanmark198
Frequent Visitor

Conditional Formatting not showing colours correctly

Hi there

I am trying to highlight the font of anything below 100% as red and anything 100% or over as Green but its not work correctly for me.  Below is my configuration:

 

madmanmark198_0-1681222714075.png

 

Can someone help please as I am sure I am doing something incorrectly here but cannot see what.

 

1 ACCEPTED SOLUTION

Hmmm okay, try changing the green row to :

 

> 1 Number and <= 100 Percent

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

View solution in original post

7 REPLIES 7
madmanmark198
Frequent Visitor

Ah yes good spot.  However after changing that it still not working as  there is an exclamation mark next to it and when I hover my mouse over that icon it says "Please check the logic of this rule".

 

madmanmark198_0-1681224044953.png

 

Ah yeah change the green value to > 99 and <= 100

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


Thank you that seemed to have worked.  However one more issue is that some of my figures are greater thenat 100% as they have over performed.  I cannot seem to say if its over 100% then it needs to be green?

Hmmm okay, try changing the green row to :

 

> 1 Number and <= 100 Percent

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Boom! It worked thank you!  I had to change the order of the rules but that is all sored now thank you so much!  

No worries, happy to help 🙂

DOLEARY85
Super User
Super User

Hi,

 

looking at the image you have both number and percentage in the dropdown selectors for the rules. Change them all to percentage

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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