Merge cells across multiple rows when values are the same

[Anonymous]

I'm trying to combine/merge cells when the values are the same for a given column. This is most easily explained with some example tables:

What I have now:

What I'm trying to make it look like:

Not sure if there's a easy way to go about this or not. Perhaps I'm not using the right search criteria, but every Google search I've tried seems to be about combining the entirety of multiple rows into one and that's not what I'm trying to accomplish. I just want my table to look clean and not repeat the same data over and over again.

[Collin_Farrell]

Under "Layout and style presets", change the "Layout" to "Tabular"

[Anonymous]

@ryan_mayu Could you elaborate a bit on this? I'm fairly new to Power BI and there's not enough detail for me to go off of. You mentioned using a matrix visualizationand while I tried that, I haven't been able to achieve what you displayed.

[ryan_mayu]

@Anonymous 

add three columns in the rows field and expand all

2. turn off stepped layout and +/-icon

3. turn off row subtotal

pls see the attachment below

[tkgraham13]

This is great but now I'm not able to do specific column conditional formatting in the "columns". Is there a way to have the background of the columns different or do a similar merge in tables vs matrix? I need background colors on the first two columns of the matrix but only see this option in the table visualization menus.

[fmor127]

I was looking for a similar solution as the OP, and this worked brilliantly for me. Thank you!

[ryan_mayu]

you are welcome

[Anonymous]

This kinda works but not enough for my purposes. It merges the duplicate value rows in the first column, however it also gets rid of duplicates in the 3rd column that I actually want to be shown. As in, you can have duplicate application companies for a server name. But instead of showing a row for each duplicate company in the 3rd row, it just merges them all into one. I thought that maybe if I added more fields to the Rows section, that it would split it out, but it doesn't. In fact, it doesn't even show the data.

[v-chenwuz-msft]

Hi @Anonymous ,

Please share a sample data with all your scenarios and the final output.

Best Regards

Community Support Team _ chenwu zhu

[ryan_mayu]

@Anonymous 

I think you can use matrix to display this format

[Anonymous]

Were you able to achieve this ?