Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Highlight specific columns in a matrix

I have a matrix like the following. I'd like to have the quarters highlighted in some way, it could be bold or coloring. The values are in the rows the columns are just columns.     Jan Feb M...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    You can use conditional background color in your matrix: 

    Measure = IF(MAX('Table'[Column]) in {"Q1","Q2","Q3","Q4"},"RED")

     

    Use it in values conditional background color:

     

     

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

     

    Best Regards,

    Dedmon Dai

     

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

You can use conditional background color in your matrix: 

Measure = IF(MAX('Table'[Column]) in {"Q1","Q2","Q3","Q4"},"RED")

 

Use it in values conditional background color:

 

 

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

 

Best Regards,

Dedmon Dai