Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I do think I see what is wrong in your original. The 2nd, 3rd, and 4th values are comparing to 'percent', not 'number':
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.
I do think I see what is wrong in your original. The 2nd, 3rd, and 4th values are comparing to 'percent', not 'number':
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.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |