Matrix heading formatting - Merge

[roger360]

Hello folks - trying to format the heading of my matrix table. %BRroc to %System Issue (7 categories) fall under Issue Category. So want to add that above all those 7 categories. At the same time want to make sure other column headings height match with the category column heading after adding Issue Category.

If I don't have anything on my table called "Issue Category" can I format the matrix table visual to add that the way I am asking for?

Current matrix table column heading:

The column heading I want to achieve (used excel to come up with the visual):

[Anonymous]

Hi @roger360,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @roger360,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @roger360,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @roger360,

Thank you for reaching out in Microsoft Community Forum.

Thank you @andrewsommer  for the helpful response.

Unfortunately, Power BI does not natively support multi-level or grouped headers directly in matrix tables. However, you can simulate the desired result by following steps below:

1.Create a Calculation Group using Tabular Editor with a calculation item named System Issue.

2.Add the Calculation Group as a column in the matrix table to act as the group header.

3.Adjust the formatting to align the header height with the other columns.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[roger360]

@Anonymous  did you mean to create Step 1 to create calculation group with Issue Category instead of System Issue?

[Anonymous]

Hi @roger360,

Thank you for reaching out in Microsoft Community Forum.

To clarify, in Step 1, you should create the Calculation Group with a calculation item named Issue Category, not System Issue. This will serve as the custom header in your Matrix table.

Please follow below steps to verify,

1.Create a Calculation Group using Tabular Editor with a calculation item named Issue Category (this will act as the group header).

2.Add the Calculation Group as a column in the matrix table to simulate the desired group header.

3.Adjust the formatting to align the header height with the other columns.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[andrewsommer]

I do not believe this is possible with the current native visuals and formatting options.  I think your best bet to achieve something like this is to utilize textboxes/shapes in conjunction with your matrix to achieve the visual design you want. 

Please mark this post as solution if it helps you. Appreciate Kudos.