Merged Column Header

[Anonymous]

How to bring the above table structure in Power BI ? If it is a Matrix table visualization, please show an example with multiple merged column headers.

[amitchandak · Accepted solution]

I do not think in powerbi you can have values above columns

refer : https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Those are not values....those are just static headers which i need.

[MFelix]

Have you checked the option I have send on pbix file?

[MFelix]

Hi @Anonymous ,

As you refer you need to use a matrix table and have a column with the categorization of your lowest values so that you are abble to get the next level. Now depending on the way you have the lowest level information (measures or coluns) the calculations can be done in different ways.

Check a small example with Columns as values in your model. Be aware that I have made this within the same table but you can make the categories on a separat table.

Also some trick was to make the Total columns for DIV and Budget Allocation hidden on the matrix by reducing the size of the columns.

[dnlxiong]

When I try to create a new matrix with my data, I cannot get the categorization to work. But when I copy and paste your visual, and then update your visual with my data, it works! Any idea why or how to create categorization with a new matrix visual? I wonder if I am not setting some properties correctly or something simple.

[MFelix]

Hi @dnlxiong ,

What do you mean by:

---

@dnlxiong wrote:

When I try to create a new matrix with my data, I cannot get the categorization to work.

---

When you create a new matrix visual by default the rows and columns are closed so you need to do the drill down:

Is this that is happening? Can you post some images of the result when you add a new matrix please so I can try and check what can be happening.

[dnlxiong]

Drilling down worked! Thanks again for the detailed guidance and screenshots!

[MFelix]

Hi @dnlxiong 

Glad I could help don't forget to accept the correct answer so it can help out others, even if it's your own answer.