Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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: ...
color
Matrix Visual
pivot
pivot table
PowerBI Report Server
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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.

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    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).