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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nick9one1
Helper II
Helper II

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
Helper II
Helper II

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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