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
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!
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 |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |