Pivot table drill down functionality in Power BI

Question

I'm trying to combine multiple large files and summarize data in Power BI.

I'm trying to move away from EXCEL because I want to use row level security and grant access to specific users. Also, excel files can become large when sharing with others.

What I'm unable to find anywhere is a drill down function in the pivot table in Power BI.

I'm unable to find this anywhere in the menus and looking at their forums people are unsure, December 2015 they were "working on it," but there have been no updates from that moderator since.

Answer 1

There is a clear deficit in the Power BI pivot table (matrix) functionality, compared to Excel. There is no drill-down or "Quick Explore" functionality yet.

If a pivot table isn't essential, you can do drill-downs on bar/column charts (which also gives you the ability to cross-filter other charts on the same page). You can go here to know more about this: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/.