Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I want to summarize the hours of certain employees. For example i have currently 4 rows with employees + hours and want to summarize them to a Team. So in Power BI there should be the Teamname instead of the employees. Can I use a group by or something like that?
I want to give them a teamname and summarize their working hours.
Solved! Go to Solution.
Hi @mafioso
Can you give the team name to employees in the dataset itself (using query editor or bring the team name from datasource itself)?
So your final dataset is something like this-
Team Employee Hours
A Milner 5
A Cook 2
B Joshua 3
B Williams 5
Now you can use Matrix visual to show Team wise summarized hours.
And the drilled down view will look like below-
Hope this helps!
Hi @mafioso
Can you give the team name to employees in the dataset itself (using query editor or bring the team name from datasource itself)?
So your final dataset is something like this-
Team Employee Hours
A Milner 5
A Cook 2
B Joshua 3
B Williams 5
Now you can use Matrix visual to show Team wise summarized hours.
And the drilled down view will look like below-
Hope this helps!
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |