Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
karthickcourse5
Frequent Visitor

How to merge two rows in PowerBI (tables)

Needed Output.png

 

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:

IdTeamEmployeeMonthTime
1AnalyticsRamApr4hrs
2AnalyticsSasiMar3hrs
3AnalyticsVisuJun2hrs
4AnalyticsKishoreJan1hr
5Advance AnalyticsAnuJan1hr
6Advance AnalyticsShriramJun3hrs
7Advance AnalyticsAdavikSep3hrs
8Advance AnalyticsNirmalAug2hrs
9Life ScienceKoushikMay2hrs
10Life ScienceXXXNov2hrs
11Life ScienceXXXDec5hrs
12Life ScienceXXXFeb5hrs
13Hi-TechXXXJul4hrs
14Hi-TechXXXAug4hrs
15Hi-TechXXXMay4hrs

 

Looking forward for your help. Thanks in advance.

2 ACCEPTED SOLUTIONS
v-lid-msft
Community Support
Community Support

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.

 

3.PNG

 

2. close the stepped layout in row headers label.

 

4.PNG

 

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

 

5.PNG

 

 

 

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.

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.

View solution in original post

Thanks for your comments. It works.

View solution in original post

6 REPLIES 6
germainewiliam
New Member

HI, the Hierarchy function is greyed out.

germainewiliam
New Member

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

germainewiliam
New Member

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
Community Support
Community Support

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.

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
Community Support
Community Support

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.

 

3.PNG

 

2. close the stepped layout in row headers label.

 

4.PNG

 

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

 

5.PNG

 

 

 

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.

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.

Thanks for your comments. It works.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors