Forum Discussion
multiple rows and columns with multiple headers
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!
4 Replies
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
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
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.
