Forum Discussion
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 | Mar | Q1 | Apr | May | Jun | Q2 | Jul | |
Actuals | 100 | 100 | 100 | 300 | 100 | 100 | 100 | 300 | 100 |
Targets | 100 | 100 | 100 | 300 | 200 | 200 | 200 | 600 | 1000 |
Variance % | 0% | 0% | 0% | 0% | 50% | 50% | 50% | 50% | 10% |
Thanks,
Sean
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
2 Replies
- amitchandak
Super User
Anonymous , I doubt there is a way. But you can do measure conditional formatting to color
a color measure like
if(isinscope(Table[qtr]), "Blue", "white") , use this in conditional formatting with "Field Value" option
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values 
v-deddai1-msftCommunity Support
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
