How to show the columns in a matrix in 2 parts

[jpsh513]

Hi everyone,

Is there any way to show the columns in 2 rows?

From this to:

To sth like this:

Thanks!

[v-zhangti · Accepted solution]

Hi, @jpsh513 

The column names of the matrix have only one row, so the second row name you expect in your diagram cannot appear.

This is the result of my test with your data.

Unfortunately, this is by design. Power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mohammedadnant]

Hi @jpsh513 

May I know the reason for this kind of requirement.?

the workaround is as follows in Power Query

1. duplicate this table 

2. split the table into 2 (Sales & Jan-may) and (Sales & Jun-Dec)

3. in table 2 (Sales & Jun-Dec) --> Transform --> Use First row as header --> Click on use header as first row 

4. Append these 2 tables pls refer to this video https://youtu.be/5UGxSFzw5W4

that's it.

If this solves your issue, please mark this answer as a solution and give thumbs up

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18