Highlight specific columns in a matrix

[Anonymous]

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

[v-deddai1-msft · Accepted solution]

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

[amitchandak]

@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