Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
I solved this by going into the cell elements, and making sure my formatting measure applid to 'Values and Totals'
This looks like a Table setting, not a Matrix.
In the Matrix, row headers are not available in the Cell Elements (2024).
This is the answer, ignore the other comments!!
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:
Voila, all of a sudden I had formatting!
You can do it by using Row subtotals, set the color on values background
Currently we can't apply conditional formatting to matrix row headers
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |