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
Zarlot531
Helper V
Helper V

How do I drill down on a matrix grand total?

I have a matrix and on every single number except for the grand total number I am able to right click and click "See records." How do I get this option available to the grand total as well? It's important to be able to see the underlying records for different slices. Thanks. 

2 REPLIES 2
Greg_Deckler
Super User
Super User

Hmm, perhaps I am not understanding what you are looking for but when I right-click on a matrix in the grand total, I see options for See Records and Show Data. 

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Attached is what I'm talking about. See how when I right click on the $19,244 it gives me the option of "seeing records." But when I right click on the 144,403 it doesn't give me that option. the "Show data" merely repeats what I can already see. Matrix1.JPGMatrix2.JPG

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.