How to show underlying record of a number in the Matrix (Power BI Desktop)?

[NickL25]

I've just migrated from Power Pivot in Excel to Power BI Desktop. As we know, in Excel's Power Pivot, double-clicking a number opens a new worksheet displaying the raw records associated with that number, with every row showing all fields. Yet Power BI Desktop seems to lack this feature entirely! Without this fundamental functionality, I'm at a loss to see the value of using Power BI Desktop for my work. Additionally, Microsoft removed the Power View control from Excel starting with the 2019 version—utterly baffling!

[v-hjannapu]

Hi @NickL25,

I would also take a moment to thank @danextian, @grazitti_sapna  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Comunity Support Team.

[v-hjannapu]

Hi @NickL25,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.

[danextian · Accepted solution]

Hi @NickL25 

Power BI Desktop doesn’t provide the exact same double-click functionality as Power Pivot in Excel where you could instantly drill into raw records on a new worksheet. Instead, Power BI is designed with a different workflow. If you want to replicate that kind of detailed record view, you can rebuild it using a matrix or table visual by adding the measures and columns you need to display. From there, you can apply the drillthrough feature so that when you right-click on a data point, you’re taken to a dedicated page that shows the underlying details (still based on the added fields) for that selection. Power BI encourages designing purpose-built detail pages rather than exposing the raw table directly.

[grazitti_sapna]

Hi @NickL25,

Unfortunately this functionality (Single click)is not available in Power BI, however you can utilize drill through functionality to view detailes for a particular cell from MATRIX view.

To achieve that create a new page with all the required you want to see and filter on clicking on the cell in the MATRIX vies. Now add the required field to drill through filter on the visual pane in the details view page.

once done, now you can right click any cell in the MATRIX visual on your main page and select drill through option and select the detail page to see the nos.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!