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 sal...
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.

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.