cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## 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%
1 ACCEPTED SOLUTION
Community Support

Hi  @manojk_pbi ,

Here are the steps you can follow：

1. Create measure.

``````Color =
var _idealRunrate=0.33
var _idealdecrease=0.28
return
IF(
"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 3
Resolver I

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.

Community Support

Hi  @manojk_pbi ,

Here are the steps you can follow：

1. Create measure.

``````Color =
var _idealRunrate=0.33
var _idealdecrease=0.28
return
IF(
"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

Solution Sage

Hi,

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.