topic Re: Need help in adding conditional font/background color in Developer

Need help in adding conditional font/background color

manojk_pbi — Fri, 14 Jun 2024 09:05:59 GMT

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%

Re: Need help in adding conditional font/background color

Kaviraj11 — Fri, 14 Jun 2024 13:48:28 GMT

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.

Re: Need help in adding conditional font/background color

Anonymous — Mon, 17 Jun 2024 01:52:40 GMT

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

Re: Need help in adding conditional font/background color

Ray_Minds — Mon, 17 Jun 2024 14:05:19 GMT

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.