Forum Discussion
Conditional formatting on another column
Hi
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?
1 Reply
Hi h4_dkj ,
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.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
