Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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:

TanujBI_0-1601759802311.png

 

But the final output should look like this as shown below:

TanujBI_1-1601759839505.png

 

Thank you in advance for the help.

2 REPLIES 2
lbendlin
Super User
Super User

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_0-1601838424844.png

 

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

 

lbendlin_0-1601848463919.png

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.