Power Pivot Drill Down

sanket_sk

Board Regular
Joined
Dec 27, 2016
Messages
140
Office Version
  1. 365
Platform
  1. Windows
Hi All,

I used Power Pivot / Chart drill-down function for the first time this week, it is an amazing feature and helped me a lot, however, I am stuck while preparing the dashboard.
When I prepare the dashboard and trying to drill down effect is applied on only one chart is there any trick by which I can drill down through all the carts by clicking on any of the charts.

Note:- Source of all the charts is the same file.

I am using the Office 365 Enterprise version.

Please guide in case of any trick

Sanket
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Hi, I dont get the picture...but if you are talking about the pivottable, then insert Slicer first... right click the slicer & click Report Connection. Now tick whichever table you want to be linked.
 
Upvote 0
Hi Tivakaran,

Thanks for the reply!!!

I am not using slicers here, what I mean is with power charts we can drill down charts using hierarchies, now I have set these hierarchies for the same set of data, once I drill down one chart the rest of the charts are idle, I am looking for a solution by which the same drill-down can be applied on rest of the charts

Sanket
 
Upvote 0
Hi Tivakaran,

Thanks for the reply!!!

I am not using slicers here, what I mean is with power charts we can drill down charts using hierarchies, now I have set these hierarchies for the same set of data, once I drill down one chart the rest of the charts are idle, I am looking for a solution by which the same drill-down can be applied on rest of the charts

Sanket
Hi,
Sorry I think I'm not appropriately knowledged for this issue.. hehe ;)
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top