multiple rows and columns with multiple headers

[Anonymous]

Hello Experts,

Any idea about how to achieve a multiple rows and columns with multiple header lines. I want the multiple rows and columns in the default layput without having to drill down. The data in the table is coming from the multiple datasets and unpivot/pivot in the dataset is not possible. I have many measure and column fields in the report with conditional formatting.

Thanks in advance!

[Anonymous]

Hey @Anonymous,

I'm not sure if your exact example is possible, but you may be ableto get close using the following: https://community.powerbi.com/t5/Desktop/Multiple-row-headers-in-Matrix-visual/td-p/372306

Granted it may require multiple iterations of your data pivoted different ways, but it should get you there.

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[Anonymous]

No, unfortunately it is not solved. We are still looking for options on this.

[v-danhe-msft]

Hi @Anonymous,

Based on my research, I am afraid you could not achieve this function without having to drill down, you could refer to below link about how to preset the layout:

https://community.powerbi.com/t5/Desktop/Double-Heading-Matrix/td-p/309886

If you do want not to use the drill down, I suggest you submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He