How to merge two rows in PowerBI (tables)

[karthickcourse5]

I have a table that contains employee details where I needed the 'Team' column to merge into one; say Analytics team should be in one row for all the employee. 

As per my client's request he is asking the output in the front end of the PowerBI visualization (dashboard) as displayed in the 'Needed output' attached the imag

Can any one please help me how I can do this in PowerBI.

Sample report:

Id	Team	Employee	Month	Time
1	Analytics	Ram	Apr	4hrs
2	Analytics	Sasi	Mar	3hrs
3	Analytics	Visu	Jun	2hrs
4	Analytics	Kishore	Jan	1hr
5	Advance Analytics	Anu	Jan	1hr
6	Advance Analytics	Shriram	Jun	3hrs
7	Advance Analytics	Adavik	Sep	3hrs
8	Advance Analytics	Nirmal	Aug	2hrs
9	Life Science	Koushik	May	2hrs
10	Life Science	XXX	Nov	2hrs
11	Life Science	XXX	Dec	5hrs
12	Life Science	XXX	Feb	5hrs
13	Hi-Tech	XXX	Jul	4hrs
14	Hi-Tech	XXX	Aug	4hrs
15	Hi-Tech	XXX	May	4hrs

Looking forward for your help. Thanks in advance.

[v-lid-msft · Accepted solution]

Hi @karthickcourse5 ,

We use the matrix visual to archive the similar result.

1. put all the field in the row field. Expand to the Final Level.

2. close the stepped layout in row headers label.

3. then you get the visual, but the ID field can only be put in the last part.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[germainewiliam]

HI, the Hierarchy function is greyed out.

[germainewiliam]

My Hierarchy button is grey out probably due to all of it are just wordings.

[germainewiliam]

Hi, 

The above works by merging it, however, it becomes an error when there is a new line item being added to the excel (after refresh) of where the new line item is not being reflected after several times of on and off of the +- function. Please assist.

[v-lid-msft]

Hi @karthickcourse5 ,

How about the result after you follow the suggestions mentioned in my original post?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft · Accepted solution]

Hi @karthickcourse5 ,

We use the matrix visual to archive the similar result.

1. put all the field in the row field. Expand to the Final Level.

2. close the stepped layout in row headers label.

3. then you get the visual, but the ID field can only be put in the last part.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[karthickcourse5 · Accepted solution]

Thanks for your comments. It works.