Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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.
HI, the Hierarchy function is greyed out.
My Hierarchy button is grey out probably due to all of it are just wordings.
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.
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.
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.
Thanks for your comments. It works.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |