Need help with Matrix Visualization

[Anonymous]

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

[v-lili6-msft]

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

[harshnathani]

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)

[Anonymous]

HI @Anonymous 

It is definatively not a possibility in Power BI.

[amitchandak]

@Anonymous , You can not merge in the middle. only initial rows can be merged.

Refer

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Greg_Deckler]

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

[mhossain]

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.