Forum Discussion
Matrix Visual match Row Header Colour with Value Colour
Hello guys. I have a Matrix visual looking like this:
To get the colouring of the values i used the Cellelements and added formating using a Fieldvalue of a helper table containing a colour code.
Is it possible to colour the row headers aswell? I have two Columns in the Rowfield of teh Matrix Visual. They should simply have the same colour as the values of the row.
It should somehow like that:
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.
6 Replies
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() )
LuITS Hi!
no, not natively, at least not in the same way you’re doing it for values with Field value conditional formatting, because Row headers cannot be conditionally formatted by field value.
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
Hi LuITS
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.Hi LuITS
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
