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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to add group in table?

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?

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

@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.

Anonymous
Not applicable

hello @Anonymous ,

could you show  the data you are refrencing

 

thanks, 

Collin

Anonymous
Not applicable

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:

 

Capture.PNG

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.