Having two levels of column header in a power bi matrix

[PaisleyPrince]

Hi,

I have an excel report structure which i wish to replicate in a Power BI matrix with two levels of column heading as per the screenshot. Could anyone please advise me of the easiest way to do this ?

many thanks

Scott

[v-pgoloju]

Hi @PaisleyPrince,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

Hi @PaisleyPrince,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution  it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @PaisleyPrince.,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @PaisleyPrince,

Thank you for reaching out to the Microsoft Fabric Forum Community.

And aslo Thanks to @bhanu_gautam for Prompt and useful response.

To replicate Excel-style grouped headers in Power BI, first unpivot your data in Power Query so each field becomes a row with "Attribute" and "Value" columns. Then, manually create a mapping table that assigns each attribute (e.g., "Location", "Employee") to a category like "Hierarchy" or "Employee Details".

Join this mapping table to your unpivoted data. In the matrix visual, add "Category" as the top level column and "Attribute" as the second. Place your value field in the Values area and your row ID (e.g., Employee) in Rows. This will give you a clean, two-layer column header just like your Excel layout.

Let us know if you need further assistance we’re happy to help. If this addressed your query, please consider marking the response as an Accepted Solution so it can assist others in the community as well.

Thank you & Regards,
Prasanna kumar

[bhanu_gautam · Accepted solution]

@PaisleyPrince 

Create a matrix visualization: Once your data is imported, create a new matrix visualization by selecting the matrix icon from the visualization pane.

Add fields to the matrix: Drag and drop the fields you want to display in the matrix into the "Rows" and "Columns" sections of the matrix visualization. You can add multiple fields to create the two levels of column headings.

Arrange the fields: Arrange the fields in the "Columns" section of the matrix visualization to create the two levels of column headings. You can drag the fields to the desired positions to achieve the structure you want.

Format the matrix: Customize the appearance of the matrix by adjusting the formatting options such as font size, color, alignment, and borders to match the Excel report structure.

[PaisleyPrince]

Hi, thanks for your input. My only query is how to deal with the first layer of headers as they are not contained in columns in the excel file ?