Forum Discussion
Merge cells across multiple rows when values are the same
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.
10 Replies
Anonymous
I think you can use matrix to display this format
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.
Under "Layout and style presets", change the "Layout" to "Tabular"
