formating a matrix based on row and column headers

[tj41901]

Dears

Started as a new developer with Power BI. i need to format the matrix based on row and column headers like below : 

either the cell background with color or the font with colored when the row and column header are same . 

please help me with this formating . 

previous	10	20	30	40	50	60
10	100
20		150
30			200
40				250
50					300
60						350

[tj41901]

Thanks  alot v-shex-msft

i have used this suggestion and its working . 

[Anonymous · Accepted solution]

Hi @tj41901,

You can set conditional formatting to apply the highlight color if the current row and column have the same values.

Measure =
VAR currRow =
    SELECTEDVALUE ( Table[Row] )
VAR currColumn =
    SELECTEDVALUE ( Table[Column] )
RETURN
    IF ( currRow = currColumn, "Red", "Black" )

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

Power BI Conditional Formatting for Matrix and Table Visuals (mssqltips.com)

Regards,

Xiaoxin Sheng