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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

[Help Needed] Accessing Records from Data Table Selections

I am struggling with what I feel is a basic question.

 

I have built a table to summarize various categories and the distinct count for each category. If i were to select a specific category (row), is there a way to access all of the records for that particular category? Similar to if you were to create a pivot table in excel and double click on a line item that would take you to all of the records for that summarized line item.

 

Thanks!

1 ACCEPTED SOLUTION
JarroVGIT
Resident Rockstar
Resident Rockstar

You might want to look at a Matrix visual rather then a table; a Matrix can be multileveled, where you can set the Categories as the primary rows, and some other column as secondary that you can collapse to.

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
JarroVGIT
Resident Rockstar
Resident Rockstar

You might want to look at a Matrix visual rather then a table; a Matrix can be multileveled, where you can set the Categories as the primary rows, and some other column as secondary that you can collapse to.

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Thank you! This worked perfectly!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.