PowerBi Table/Matrix with multiple column

[Anonymous]

Hi All,

I want to use an matrix or table in PowerBi, where i can add 02 or more columns seprately(as per imange below). I am unable to acheive the same in default PowerBi Table/Matrix.

Is there any way i can achieve the same in default (By scipting) or do i need to import a new Tabel/Matrix from market place.

Regards,

Ashraf 

[v-lionel-msft]

Hi @Anonymous ,

As tested, the current version of Power BI can’t realize what you need completely (My version: 2.75.5649.761 64-bit (November 2019)). Because I also didn’t find any visuals to realize what you want in marketplace.
But you can use matrices and drill-through to achieve a similar effect.

Maybe you can submit your ideas to Power BI Ideas:

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

Best regards,
Lionel Chen

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

[PBIdashboards]

This has changed significantly since the original answer native Power BI has improved the Matrix visual considerably. For the multi-measure grouped column layout you're describing, try using a Matrix with multiple Values and enabling "Show on Rows" under Values settings. For full flexibility where users can add/remove columns themselves after publishing (which native Matrix still can't do), Flexa Tables on AppSource handles this. Users drag in whatever columns they want directly in Power BI Service.