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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
Kirthiga
New Member

Format top row headers alone in Matrix visual

Hi Colleagues,


I would like to do the below formatting in OOB Power BI matrix visual,

1. Only the top level row header background colour has to be changed, if possible change the height of this as well

2. If a subcategory has blank values, then that should not be shown in the hierachy levels.

Example image for clarity:
OOB Matrix Visual:

Kirthiga_0-1747819739065.png

The formatting that I am looking for:

Kirthiga_1-1747820014034.png

Thanks in advance😊

1 ACCEPTED SOLUTION
v-veshwara-msft
Community Support
Community Support

Hi @Kirthiga ,

Thanks for reaching out to Microsoft Fabric Community.

Thanks for the detailed explanation and screenshots.

As already pointed out by @Elena_Kalina  and @Brianyoung , Power BI doesn’t allow applying background color to only the top-level row header. The formatting applies to all row headers at that level. Adjusting the height of just the top-level header isn’t supported either. Custom visuals from AppSource may help if more granular formatting is needed.

 

Regarding the blank subcategories, since they still contribute to aggregated values, the Matrix visual treats them as valid entries. You can consider adding a measure to filter out the blanks at the visual level if needed.

 

Hope this helps. Please consider marking the helpful reply as Accepted Solution and giving kudos to assist others with similar issues. Let us know if you need further help.

 

Thank you.

View solution in original post

6 REPLIES 6
v-veshwara-msft
Community Support
Community Support

Hi @Kirthiga ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

v-veshwara-msft
Community Support
Community Support

Hi @Kirthiga ,

Thanks for reaching out to Microsoft Fabric Community.

Thanks for the detailed explanation and screenshots.

As already pointed out by @Elena_Kalina  and @Brianyoung , Power BI doesn’t allow applying background color to only the top-level row header. The formatting applies to all row headers at that level. Adjusting the height of just the top-level header isn’t supported either. Custom visuals from AppSource may help if more granular formatting is needed.

 

Regarding the blank subcategories, since they still contribute to aggregated values, the Matrix visual treats them as valid entries. You can consider adding a measure to filter out the blanks at the visual level if needed.

 

Hope this helps. Please consider marking the helpful reply as Accepted Solution and giving kudos to assist others with similar issues. Let us know if you need further help.

 

Thank you.

Elena_Kalina
Solution Sage
Solution Sage

Hi @Kirthiga 

  • Power BI doesn't allow direct height adjustment for individual rows

  • The background color change will apply to all headers at the same level

  • For dynamic row colors, you would need to use a custom visual from AppSource

  • Since subcategories are placed in rows and the column uses aggregation (sum), the matrix treats them as valid entries as long as they contribute to the aggregated value—regardless of whether their label is blank.

Here’s an example of the maximum possible customization you can apply to the matrix visual

Elena_Kalina_0-1747823833197.png

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

Hi @Elena_Kalina , thank you very much for the detailed explanation.

Your second points seems interesting to get to know more about it. Because when I tried to apply some background colour to row headers, it gets reflected to the entire header irrespective of the levels they are in. If you could point the steps to it, it would be more than helpful.

This is how it looks when I apply the background color to the row headers.

Kirthiga_0-1747832244312.png

The Dummy data structure that I am using.

Kirthiga_1-1747832296320.png

Thanks again!






I'm providing some screenshots for you

Elena_Kalina_0-1747833144029.pngElena_Kalina_1-1747833180705.png

 

Brianyoung
Regular Visitor

Power BI doesn’t let you format just the top row headers in a matrix separately. You can change the overall header style, but for more detailed formatting, you might need to use custom visuals or workarounds like creating your own header rows inside the data.

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.