Forum Discussion
Adding Custom Column Headers in Matrix visual on Top of existing column headers
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.
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.
4 Replies
- Greg_Deckler
Community Champion
Gokulg See if this helps: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
- GokulgFrequent Visitor
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
- V-lianl-msft
Community Support
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.
- oalgarvioFrequent Visitor
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.