Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table conditional format one column based on another column

  Hi  How do I format Q1 rows based on their targets? I.e. Dept A, Q1 should have the 15000 in green  but Dept B should have the 100 in red. I've tried the other posts similar to this, but...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    According to your description, here’s my solution.

    1.Create a measure.

    Color = IF ( MAX ( 'Table'[Q1] ) > MAX ( 'Table'[Targets] ), "Green", "Red" )

    2.Turn on the Font color option in Conditional formatting.

     

    3.Select the measure as the based on field.

     

    4.Get the expected result.

     

    Best Regards,
    Community Support Team _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

According to your description, here’s my solution.

1.Create a measure.

Color = IF ( MAX ( 'Table'[Q1] ) > MAX ( 'Table'[Targets] ), "Green", "Red" )

2.Turn on the Font color option in Conditional formatting.

 

3.Select the measure as the based on field.

 

4.Get the expected result.

 

Best Regards,
Community Support Team _ kalyj

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Perfect! Many thanks for that - much appreciated.