Forum Discussion

Kirthiga's avatar
Kirthiga
New Member
1 year ago
Solved

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 a...
Need Help
Tips and Tricks
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    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's avatar
Elena_Kalina
Solution Sage
1 year ago

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

 

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.