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.