Forum Discussion
tj41901
4 years agoNew Member
formating a matrix based on row and column headers
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...
- Anonymous4 years ago
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
tj41901
4 years agoNew Member
Thanks alot v-shex-msft
i have used this suggestion and its working .