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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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