Sub Headers for Columns in Power BI Table

[Anonymous]

Hi All,
Is the below visual possible in Power BI. The Sales column should have two or more sub headers. 

Thanks in Advance for the help.

[v-gizhi-msft · Accepted solution]

Hi,

Please take following steps:

1)Unpivot [Commericial] and [Resdential] column.

2)After Apply&Close, create a new column:

. = "Sales($)"

3)Choose matrix visual, the result shows:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto

[amitchandak]

You need to have for everything. You can have empty for others

https://community.powerbi.com/t5/Desktop/Give-Columns-Shared-Header/m-p/994813

[Mariusz]

Hi @Anonymous 

The matrix visual can create sub column, however, it can not be applied only to a specific column, it has to be all or nothing.

Otherwise, it can be achieved easily using Paginated Reports if you have Premium 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn