Powerful Feature: Drill Down/Drill Up Feature in Pivot Chart

#PowerPivot #PivotChart
Hello Friends,
In this video, you will learn how to created Drill Down/Drill Up Feature in Pivot Chart. We have used hierarchy in Power Pivot data mode to create this. This feature can make your dashboard or report more powerful.
Please download the practice file from below given link:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

[@ekkiwurm7874]

Excellent video. Actually one of the best and most helpful videos that I watched lately. Thank you sooooo much for producing and sharing it. You made my day! 😀

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jackjohansson10]

Thank you for explaining how to create a hierarchy. You are a lifesaver

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@nsanch0181]

PK that is amazing! Thank you soo much for showing that feature. I'm not sure if I would have ever ran into that feature if not for you. I would never have guessed that charts could be double clicked and drilled down like that either. You made my morning again!. Thank you.

[@Luciano_mp]

Congratulations, I didn't know the drill down in charts. The graph was very interesting. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@virenderjal]

Congratulations, I didn't know the drill down in charts. The graph was very interesting.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@virenderjal]

Hi Sir, can we change the colour on every step (hierarchy)

[@md.arafat7403]

Great!! Thanks brother for keeping your word to make tutorial on power pivot.Expecting tutorials on DAX formulas.

[@PKAnExcelExpert]

Thanks for your valuable feedback. More videos are coming soon

[@aartikaushalkaatharv]

Thank you so much brother for sharing your knowledgeable Videos ❤️❤️❤️

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@banktig]

Thanks so much
😀

[@PKAnExcelExpert]

Most welcome

[@bharathn4524]

To be frank you have become my Guru, i have learnt lot of things looking at the videos that you post.
i have one query in this Drill down/Up - how do you do it for the values having in percentage and how do you Convert 2 value into percentage and then do drill up and down.
Could you please help me with this Guruji

[@sidhartan]

Informative

[@PKAnExcelExpert]

Thanks

[@shankerhs9667]

Awesome😲

[@PKAnExcelExpert]

Thanks 🤗

[@amirsaiftaz]

Thanks Guru ji for this useful tip n trick

[@PKAnExcelExpert]

Thanks Amir for your valuable feedback

[@enemieskiller5537]

Always Amazing and brilliant 👌👌👌👌👌💖💖

[@deepaknagar5697]

Sir you make excel so interesting, so pop video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ahaw4133]

Thank you nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gameanand]

Awesome. Should be the most awesome and easy task

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@airazu9851]

very helpful, Many thanks, How can create pivot chat with grand total in linner

[@mohammedaltaf4877]

Really a great job thanks

[@PKAnExcelExpert]

Thanks Altaf for your valuable feedback

[@tobayekaina8610]

Hi PK awsome. Thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandrakantmagaji1568]

Very nice...and helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DM-YouTube]

Very much useful information. Didn't know about it earlier. However it's not working on protected sheet. Any solution to this?

[@rahulshewale9206]

Thank you so much for video sir
Please make on video context trascition &filter context

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video very soon

[@rahulshewale9206]

@@PKAnExcelExpert I am learning lot from you sir

[@magiemacaraig1742]

Awesome video. Question though, can we still add timeline and slicers for this kind of chart?
Thanks in advance :)

[@rawatvlogs2685]

Excellent sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lukev730]

Wonderful PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@serigamel]

Hi, is there an easier way to drill up instead of selecting a slice, right clicking and selecting? I tried creating a macro and assigning it to a shape as a button but it doesnt work for drilling back up from any slice.

[@zuhebkhan6973]

Hello Sir Thank so much..on you videos...from you support I have reached to in good position.. Sir Just want ask you...the drill down chart..will it work on protected sheet...plse help me in this with your reply...it will be great help

[@jbetts2108]

Thanks. The only issue I'm having, is that when you get to the last drill down (ex: product label) you can't tell which employee its for. Maybe it's just a column labeling issue for me. Any thoughts?

[@srinivasdeekonda8901]

Hi sir.. nice video.. but do the pivot chart drill down is not working in 2010 excel... is there any posibility to get it worked as my org is using 2010

[@Hamidi_Ben]

excelent it's great as a tip

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@carlosrobertomartinezandra9120]

Lo Maximo....!!!!

[@GauravSharma-gc6vw]

Hello sir
Hope you are doing good.
Recently I have started watiching your videos ans helped me alot.
Just wanted to clarify a doubt.
I have created a dashboard with dynamic raw data for pivot table.
Now i am using this drill down chart can we use dynamic rawdata in this as well, if yes than hiw to do it need little guidance on that.
Looking forward for your reply

[@PKAnExcelExpert]

Hi Gaurav,
Thanks for your valuable feedback. You can table in your and load to power pivot data model. It will be always dynamic.

[@durgesh91tomar]

Great....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kamalelyaakoubi7020]

Very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arindambhattacharya8127]

Can I drill through two charts simultaneously in Power Pivot?

[@akakarun8]

Wonderful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@carlosdanielriosvillarreal1872]

Amazing. A question, can we use drill up/drill down and expand/collapse in slicers? Thanks.

[@MomsKitchenIndia143]

Love it

[@PKAnExcelExpert]

Thanks

[@DilipTiwariVlogs]

Awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arindambhattacharya7848]

This does not work(roll up/roll down) when we put slicers

[@ansumanmohanty4761]

Can we create drill down column chart under pie chart?

[@mohamadfawaz1928]

wow

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@totvabe1]

Is it possible to do something similar in Power BI?

[@PKAnExcelExpert]

Yes, it is possible. I will definitely try to make such video very soon

[@aquamarine76]

AJDE GENI kAMENI

[@aquamarine76]

THOMPSONE KRALINO!!!!!