Need help in adding conditional font/background color

[manojk_pbi]

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%

[Ray_Minds]

Step 1: - Right click on the measure/column for which you would like to apply
the formatting rule

Step 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.

[Anonymous · Accepted solution]

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

[Kaviraj11]

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.