Merge cells in tabular visualization

[Narukkp]

Hi Team,

Can we merge the cell data in power bi. I mean how we do in Excel. PFB existing data and required output

Existing data :

Country	City	Year	Sales	Target Reached
IND	Hyd	2016	500000	Yes
IND	Hyd	2017	400000	No
IND	Hyd	2018	70000	Yes
IND	Blore	2017	550000	Yes
IND	Blore	2018	650000	Yes
US	AZ	2018	700000	Yes
US	AZ	2017	400000	No
US	AK	2017	5000000	Yes
US	AK	2018	34000	No

Output

[Emma_Apted]

In case anyone else is trying to find this option in a more modern version of PowerBI, it's under Visualizations -> Format -> Visual -> Layout and style presents -> Layout: Outline. Then ensure "Repeat row headers" is turned off.

[StefArroyo]

Hi! I tried implementing this solution and I no longer see within the matrix view.

[v-xuding-msft · Accepted solution]

Hi @Narukkp ,

You can implement it using a matrix.

Drag the column to the Fields -- > turn off the option of Stepped layout -- > turn off the option of Row subtotals -- > expend all down one value in the hierarchy

Best Regards,

Xue Ding 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hi_cunglamdata]

Hi Xue Ding,

I have tried your instructions (Off 'Stepped layout', Off 'Row Subtotal' and Click on 'At the lowest level of data') but the result shows only 1 row (instead of 4 rows as in the below images).

Please help to check.
Thank you so much.
Kha

[Narukkp]

Thank you