Value Formatting Matrix Visual

[Anonymous]

I've been trying to duplicate the format of a design I found on the web. I think there's an error with the Value formatting for the Matrix visual. 

I'm trying to format the drilldown rows as one color, and the drill up as another. When I click on "Background Color" under Values, and change the color, it does what I expect. When I then click on the same color for the "Alternate Background Color" it changes all the color for the values, and removes color from the field names. The first image is an example, where the drill downs are a differnt color from the drill ups, which is what I would like to reproduce.

I'm including a few screen shots, because I have no other way to explain it.

Additionally, the Style is set to "none."

[MFelix · Accepted solution]

Hi @Anonymous ,

To do this you need to have the different parts of the table formatted individual:

• Style: none (match as you have)
• Column Headers:
  • Font Colour: Black
  • Background Colour: White
• Column Headers:
  • Font Colour: Black
  • Background Colour: Gray
• Values:
  • Font / ALternate Font Colour: Black
  • Background / Alternate Background Colour: White
• Sub Totals:
  • Font Colour: Black
  • Background Colour: White
  • Apply to labels: On (believe this is what is not matching in yours)
• Grand Total:
  • Font Colour: Black
  • Background Colour: White
  • Apply to labels: On (believe this is what is not matching in yours)

You can change the Colour to whatever you want.

Check PBIX file attach.

Regards,

MFelix

[Anonymous]

@MFelix  You're a wizard! Great explanation. Appreciate the help.