Conditional formatting

[Anonymous]

Hi,

I want to format a percent values in a finance report. If the sales variance is negativ then the font colour should be red. The cost variance should be red, if it is positive. To define what sales an costs, I have a related table.

Is this able to format in Power Bi?

Thanks in advance

Catalano

[isabella · Accepted solution]

Hi @Anonymous 

You can create a measure，then fomat the column backgroud color in table using this measure

Create a measure:

ColorSalesVarianceMeasure = IF(MAX('Tabletest'[sales variance])<=0,"red","#ffffff")

Best Regards,

Community Support Team _Isabella

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

[sanalytics]

@Anonymous 

It is advisable tat if you post some dummy data and your exact requirements..It will help us to solve your problem.

Please go though the below link, how to get the answer quickly

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message

Hope this will help

Regards

sanalytics