Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have a list of contacts that I just want to group by manager. I tried matrix table and added Manager to Rows, but it is only showing ONE contact per manager...can someone help?
@Anonymous ,
You may refer to documenatation about Group in power bi desktop. https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello @Anonymous ,
could you show the data you are refrencing
thanks,
Collin
I have a list of contacts, each assigned to a manager. I want to group the data by manager. I used a matrix table but it only lets me select "First, Last, Count (Distinct), or Count" in the Values. So I'm forced to display only ONE contact per manager.
I want the data displayed like this:
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |