Adding Custom Column Headers in Matrix visual on Top of existing column headers

[Gokulg]

Hi,

Im using matrix visual in report, so in that we have Rows and Columns. My requirement is to display another one row of Column header on to of existing column headers. Below is sample image in which we need to manually add the highlighted top level column headers. Please suggest to achieve this

 Note : We already tried adding Textbox on top of matrix to display the highlighted header but sometimes matrix visual have scroll bar when we have more columns, so at this time of horizontal scroll the Textbox headers are not in alignment with Matrx visual.

[V-lianl-msft · Accepted solution]

Please create a hierarchy according to your needs and place it in the column fields of the matrix visual.

Click Format pane and set the center alignment.

[oalgarvio]

I'm facing the same problem. I'm not understanding how to create a hierarchy in order to obtain a second header attributed to at least two columns. Can you help me? Can you be more specific about how to create the hierarchy? Thank you in advance.

[Greg_Deckler]

@Gokulg See if this helps: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[Gokulg]

Hi @Greg_Deckler,

Thanks for sharing, actually in my scenario there is no relation between top level highlighted column header and column headers, so if i use custom hierarchy there should be some matching fields between highlighted header and non-highlighted header. Is there any other way to achieve this

Thanks,

Gokul