Forum Discussion
Require Color Coding For Pivot Table in Matrix Visual (Power BI Server - May 2020)
Hi,
Can someone please help me to color code the entire row based on the text value for "Bench category" even if the value is empty or null.
Right now in BI, I have obtained below output:
But the final output should look like this as shown below:
Thank you in advance for the help.
2 Replies
That turns out to be surprisingly difficult. I thought I could do it with a cross join but it looks like it might require extra measures too.
One thing that seems entirely impossible at the moment is to put a background on the row headers.
Still working on it.
This is the closest I got - using a fake measure (Val := "") to fill in the gaps in the cross join between category and aging bucket, and then hide the columns for that measure (minimize their width).
