Forum Discussion
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 = 33+5 = 38% & 33-5 = 28%
Logic for font color - RunRate >= 28% && <=38% -> Green, Red
| PRJOECTS | #Prj | Run Rate |
| PRJOJECT1 | 18 | 34% |
| PRJOJECT2 | 11 | 39% |
| PRJOJECT3 | 12 | 27% |
| PRJOJECT4 | 8 | 33% |
| PRJOJECT5 | 9 | 36% |
| PRJOJECT6 | 4 | 34% |
| PRJOJECT7 | 25 | 36% |
| PRJOJECT8 | 12 | 34% |
| PRJOJECT9 | 13 | 36% |
| PRJOJECT10 | 9 | 43% |
| PRJOJECT11 | 8 | 46% |
| PRJOJECT12 | 4 | 32% |
| PRJOJECT13 | 0% |
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
3 Replies
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,
Please follow the steps here:
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Opt for the Rules under Fotmat Style and select RunRate and the apply the condition & colors accordingly.
If need any other help, let me know.
Step 1: - Right click on the measure/column for which you would like to apply
the formatting ruleStep 2: - In our scenario, we need to apply a conditional
formatting on Font color which can be selected by right clicking on the conditional
formatting option: -Step 3: - Apply the below logic and click on OK.
Output : -
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
