Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hi
Here is my data table.I just want add colour codes with the following rules. (95% - 100% = Green , 90-94% = Yellow, below 90 is red).I tried to use the conditional formatting option in the format table.But wrongly showing colour codes... Can someone help me solve this.. Thanks - Kavitha Ghosh
Solved! Go to Solution.
Hi @Anonymous
You can try this as a workaround.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes It works.Thanks
@Anonymous
show, please, your Conditional Formatting dialog box
@Anonymous
I see numbers, not percent here
Hi
Its not working Even after ichenget to percent..
Its not working even after changed to percent.
Hi @Anonymous
if so, Im not sure how do you calculate [Fac IRA] field. it could depends on aggregation
but you can try to change percents to number in Conditional formatting dialog box and set rate as numbers:
0.95-1
0.9-0.95
0-0.9
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |