Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerBi Table/Matrix with multiple column

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 ...
Tips and Tricks
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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's avatar
    PBIdashboards
    Post Patron
    2 months ago

    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.