Forum Discussion
How to put 2 columns side by side in a matrix vs drill down?
Hello everyone,
I want to create a pivot table in Power BI with the variables: Type, Country, Gender, Income of people. I want to have the Country and Gender variables in the same column matrix, side by side, with no hierarchy between the two. I need your help please. I'm using Power BI Desktop version 2.137.751.0 64-bit
Thanks in advance.
2 Replies
Hi tchoffo ,
As far as I know, placing two fields in a matrix column creates a hierarchical structure in the order in which they are placed, and this is the design of Power BI. You can consider customizing the matrix layout by following the link below, which requires creating a new table and changing the layout of the data, or by considering combining the two columns into a single column.
Creating a “custom” or “hybrid” matrix in PowerBI - Microsoft Fabric Community
The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
You can submit an idea for it at Home (microsoft.com) 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,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thanks for your reply. I submitted the idea and am waiting to see the votes and decision.
Best Regards,
Tchoffo
