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

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

 

PBI - Value Formating Example.PNGPBI - Value Formating 1.PNGPBI - Value Formating 2.PNGPBI - Value Formating 3.PNGPBI - Value Formating 4.PNG

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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.

formatting.png

 

Check PBIX file attach.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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.

formatting.png

 

Check PBIX file attach.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.