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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Resident Rockstar
Resident Rockstar

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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