formating a matrix based on row and column headers

Question

DearsStarted as a new developer with Power BI. i need to format the matrix based on row and column headers like below :&nbsp;either the cell background with color or the font with colored when the row and column header are same .&nbsp;please help me with this formating .&nbsp;&nbsp;previous10203040506010100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20&nbsp;150&nbsp;&nbsp;&nbsp;&nbsp;30&nbsp;&nbsp;200&nbsp;&nbsp;&nbsp;40&nbsp;&nbsp;&nbsp;250&nbsp;&nbsp;50&nbsp;&nbsp;&nbsp;&nbsp;300&nbsp;60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;350

anonymous · Accepted Answer

Hi&nbsp;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

Forum Discussion

formating a matrix based on row and column headers

2 Replies

Related content

Conditional formatting in power bi matrix row headers

Matrix Row Conditional Formatting

Matrix formatting

Formatting Column headers in matrix

Formatting Matrix Visuals

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