Conditional formatting on another column

h4_dkj — Wed, 09 Jun 2021 10:33:36 GMT

I am trying to conditional format my finance result each month compared to the budget

The table

Comapany	Finance mont 1	budget mont 1	Finance month 2	budget month 2	Finance month3	budget month 3
1	- 5	-4,5	-4.1	4,5	-6	-5,2

I have created a KPI Color DAX:

KPI_1_1_Color = IF(SUM('BUDGET_COMMITMENTS (2)'[KPI_1_1_Virkelig]) > SUM('BUDGET_COMMITMENTS (2)'[KPI_1_1_Budsjett]), "#69b00b"

,"#f44242"

)

I then use this on my visual and choose conditional formatting. Setting background color to my measure.

Then apply it.

The table should look like this

Comapany	Finance mont 1	budget mont 1	Finance month 2	budget month 2	Finance month3	budget month 3
1	- 5	-4,5	-4.1	4,5	-6	-5,2

How ever the finance month 2 get the color green as wel. It should be red.

Any ideas on what I am doing wrong?

Re: Conditional formatting on another column

V-lianl-msft — Fri, 11 Jun 2021 06:51:53 GMT

DAX measure is based on the current row context, it is recommended that you check that your model meets the requirements for using this measure.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.