Forum Discussion
Merge cells across multiple rows when values are the same
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.
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
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.
Hi Anonymous ,
Please share a sample data with all your scenarios and the final output.
Best Regards
Community Support Team _ chenwu zhu
I was looking for a similar solution as the OP, and this worked brilliantly for me. Thank you!
you are welcome
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.
