Forum Discussion
Solved
Need help in adding conditional font/background color
Hi, I have data like below in a table RunRate is a measure. I would like add folor color based on logic. Pls help me how can it be done. idealRunrate : 33% idealRate +/- 5% tollerance IdealRate...
Hi manojk_pbi ,
Here are the steps you can follow：
1. Create measure.
Color = var _idealRunrate=0.33 var _addidealRate=0.38 var _idealdecrease=0.28 return IF( MAX('Table'[RunRate]) >= _idealdecrease&&MAX('Table'[RunRate])<=_addidealRate, "Green","Red")2. Conditonal formatting – Background color.
3. Background color – RunRate.
Format style – Field value/
What filed should we base this on – [color]
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi manojk_pbi ,
Here are the steps you can follow：
1. Create measure.
Color =
var _idealRunrate=0.33
var _addidealRate=0.38
var _idealdecrease=0.28
return
IF(
MAX('Table'[RunRate]) >= _idealdecrease&&MAX('Table'[RunRate])<=_addidealRate,
"Green","Red")2. Conditonal formatting – Background color.
3. Background color – RunRate.
Format style – Field value/
What filed should we base this on – [color]
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly