Pivot table drill down functionality in Power BI

0 votes
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.
Dec 3, 2018 in Power BI by Shubham
• 12,150 points
308 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

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/.

answered Dec 3, 2018 by Upasana
• 7,560 points

Related Questions In Power BI

0 votes
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,080 points
1,090 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by CHERUKURI
• 13,060 points
58 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5 in Power BI by Phalguni
• 750 points
22 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered 4 days ago in Power BI by Avantika
• 1,060 points

edited 4 days ago by Omkar 21 views
0 votes
1 answer

Embed URL-multiple filters in Power BI

With the release of 2.0.0 you can ...READ MORE

answered Oct 16, 2018 in Power BI by Annie97
• 2,190 points
435 views
0 votes
1 answer

Passing a parameter to Power BI Embedded via embedded URL

Add the following to the end of ...READ MORE

answered Oct 23, 2018 in Power BI by Annie97
• 2,190 points
644 views
0 votes
1 answer

powerbi embeded in .net core 1.1

See if it helps: https://www.nuget.org/packages/PowerBI.NetStandard ...READ MORE

answered Nov 28, 2018 in Power BI by Upasana
• 7,560 points
45 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 7,560 points
30 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 7,560 points
119 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.