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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
saranee
Helper I
Helper I

Ungrouping rows

Hi everyone,

 

Need a little help on this 

 

When we are presenting data(say for e.g:Name,Marks) in matrix,it is getting grouped by Name like:

 

originally comingoriginally coming

 

But we need Name in each row like:

requiredrequired

 Please can you let me know how to ungroup Name.

 

Any help is much appreciated.

 

Thanks,

Saranee

 

 

 

3 REPLIES 3
Anonymous
Not applicable

Try using a "Table" visual, instead of a "Matrix" visual, and ensure any subsequent columns are set to "Don't Summarize".

 

Although, based on your sample screenshots, it's a little unclear as to what your data actually looks like, and what you're actually trying to show.

Thanks for your reply.But we can not use table visualization in this case.Name column is unsummarized only.

Please let me know if we can implement this thing keeping matrix as visualization.

 

Thanks,

Saranee

Anonymous
Not applicable

@saranee,

How do you store data in your original table? If your original table looks like below, you can only use table visual to get expected result. In Matrix visual, the marks are automatically summarized for each name.
1.JPG


Regards,
Lydia

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors