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 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 

Tips and Tricks

2 Replies

  • 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.