Forum Discussion
Matrix Visual match Row Header Colour with Value Colour
Remove (or minimize) the row header usage.
Create a “Row Label” measure/column and place it in Values as the first column.
Apply the same conditional formatting (field value) to that “Row Label” value.
This gives you a “header-looking” first column that can be colored exactly like the row.
Remove (or minimize) the row header usage.
Create a “Row Label” measure/column and place it in Values as the first column.
Apply the same conditional formatting (field value) to that “Row Label” value.
This gives you a “header-looking” first column that can be colored exactly like the row.
cengizhanarslan
Thank you for the answer. Two Questions.
1. In my Matrix i have Months in the Columns which means when i add a meassure to the Values it gets duplicated for every Month diplayed. Is there a way to show this meassure only at the start of the Matrix/Vaulue part.
2. Can you tell me how this meassure would look like? In my Matrix i have two columns in the row attribute creating a little hierarchy which i can expand with te +/- Buttons of the Matrix. How can the meassure show me the according values of the two levels?
1. You can sort of hide column headers by formattin background/font colour and minimize text size as possible. This way you would have only 1 row as headers but dont forget it is actually a measure so that you wont be able to use it as header options like sorting etc.
2. I am not sure how your data and model is but I think the measure has to be like below:
Row Label = SWITCH ( TRUE(), ISINSCOPE ( 'DimPnL'[PositionLevel2] ), SELECTEDVALUE ( 'DimPnL'[PositionLevel2] ), ISINSCOPE ( 'DimPnL'[PositionLevel1] ), SELECTEDVALUE ( 'DimPnL'[PositionLevel1] ), BLANK() )