Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help with Matrix Visualization

Hi Team, 

Is there any way to merge more than 1 row in Power BI, like we have option to merge the cells in Excel. The requirement is to present the data in the attached format. Any quick help is really appreciable.

 

Regards, 

Arushi

6 Replies

  • mhossain's avatar
    mhossain
    Solution Sage

    Hi Anonymous 

     

    I think yes that is doable in PowerBI matrix table, when you turn off the stepped layout in the row header format setting.

     

    In your pic 3rd columns showing bigger merge then second column, I think this will be a problem, probably you would require to change the row placement in your matrix table.

     

    Let me know if above makes sense.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous - Yeah, no. I don't know of any way to do that in Power BI matrix visual!

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous 

    It is definatively not a possibility in Power BI.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Not sure if the usecase which you are trying will work in any Power BI Visual.

     

    Here is what all you can try with a matrix.

     

    https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
    20 tricks to finally master the Matrix visualization in Power BI!! --> https://www.youtube.com/watch?v=58a2rIV2nYg

     

    See if any of these can help

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi  Anonymous 

    For Values in matrix, it could not achieve that merge them as excel in power bi matrix visual for now, 

    you may submit an idea in here.

     

    Regards,

    Lin