How to change background color of value A according to the percentile of value B?

[gdxy]

In my case, there are many KPIs with different weightings, how can I change the background color of 'Value’ according to 'KPI Weighting'?
For example,
when Value >= 90% of KPI Weighting, the background will become green;
when Value >=80% of KPI Weighting & < 90% of KPI Weighting, the background will become yellow;

when Value < 80% of KPI Weighting, the background will become red.

Thank you

[amitchandak · Accepted solution]

@gdxy , You can create a color measure and use that in conditional formatting using field value option

Switch(True(),

[Value] >= .9 , "Green",

[Value] >= .8 , "Yellow",

"Red"

)

Learn Power BI Advance - PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

[gdxy]

Thank you for your solution, it works for me!