Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional formatting

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

Need Help
  • isabella's avatar
    isabella
    4 years ago

    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.

2 Replies

  • isabella's avatar
    isabella
    Microsoft Employee
    4 years ago

    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.