cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nick9one1
New Member

conditional formatting not applying

Can anyone see what's wrong here? 

 

the word silver should be grey, not red. 

nick9one1_0-1656953746531.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

I do think I see what is wrong in your original.  The 2nd, 3rd, and 4th values are comparing to 'percent', not 'number':

jdbuchanan71_0-1656958061867.png

 

View solution in original post

3 REPLIES 3
nick9one1
New Member

Thank you. Both solutions work.


I ignored the 'percent' selection as it was grayed out so didnt expect it to be doing anything. 

However, changing the 'appy to' option to Values, not Values and Totals makes it available again.  
I could then change it to 'number'.
Changing back to values and totals then worked and displayed the correct colour. 

jdbuchanan71
Super User
Super User

I do think I see what is wrong in your original.  The 2nd, 3rd, and 4th values are comparing to 'percent', not 'number':

jdbuchanan71_0-1656958061867.png

 

jdbuchanan71
Super User
Super User

You could try it with a measure that returns the color you want instead, like this.

2020 Average Rating Color =
SWITCH (
    [2020 Average Rating],
    "Bronze", "#6A3805",
    "Silver", "#B4B4B4",
    "Gold", "#C9B037",
    "Unrated", "#B70000"
)

Make sure the measure is formatted as text and apply the conditional formatting based on a field value.

jdbuchanan71_0-1656955803246.png

 

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors