Forum Discussion
Value Formatting Matrix Visual
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 ...
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
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
MFelix You're a wizard! Great explanation. Appreciate the help.