Forum Discussion
Conditional formatting in row header in Matrix table.
Hi all,
How I supposed to perform a conditional formatting on a row header in Matrix table?
I have two rows headers anfI want that one of them will be in specific color - please find the attached picture:
I would like that only the tasks will be colored in blue color (for example).
I tried to create additional column due to do thi, however it's ignored the PI row header (plese find the picture below):
My desirable result supposed to be like that:
Does anyone has solution to this?
Thanks a lot!
7 Replies
Currently we can't apply conditional formatting to matrix row headers
I solved this by going into the cell elements, and making sure my formatting measure applid to 'Values and Totals'
I have no idea why this worked, but I was really struggling to get formatting to work on the row headers. I searched all over the community and was not seeing any answers. I was clicking around and for some reason that I don't understand, it's working now.
Here's what I did:
- Removed header row from matrix
- added header row back to matrix in the bottom position of the rows container.
- Moved it back up to top position (header row)
Voila, all of a sudden I had formatting!
Thank you - this is still a working solution for Matrix / Compact Layout
Removing then re-adding the Rows data field, and moving it to the top allowed the existing formatting set to apply to the parent row.
Would be nice if we could also format the Row colours, but I'll take it as a win.
Thank you!
