cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors