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

[@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

[@leogomez9088]

Thanks amigo

[@PKAnExcelExpert]

Most welcome

[@enemieskiller5537]

Always Amazing and brilliant 👌👌👌👌👌💖💖

[@amirsaiftaz]

Thanks Guru ji for this useful tip n trick

[@PKAnExcelExpert]

Thanks Amir for your valuable feedback

[@gameanand]

Awesome. Should be the most awesome and easy task

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shankerhs9667]

Awesome😲

[@PKAnExcelExpert]

Thanks 🤗

[@mohammedaltaf4877]

Really a great job thanks

[@PKAnExcelExpert]

Thanks Altaf for your valuable feedback

[@deepaknagar5697]

Sir you make excel so interesting, so pop video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandrakantmagaji1568]

Very nice...and helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tobayekaina8610]

Hi PK awsome. Thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@banktig]

Thanks so much 😀

[@PKAnExcelExpert]

Most welcome

[@sidhartan]

Informative

[@PKAnExcelExpert]

Thanks

[@lukev730]

Wonderful PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rawatvlogs2685]

Excellent sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@leogomez9088]

Gracias cumpa

[@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

[@ahaw4133]

Thank you nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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

[@airazu9851]

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

[@MomsKitchenIndia143]

Love it

[@PKAnExcelExpert]

Thanks

[@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.

[@kamalelyaakoubi7020]

Very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@magiemacaraig1742]

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

[@Hamidi_Ben]

excelent it's great as a tip

[@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?

[@akakarun8]

Wonderful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@durgesh91tomar]

Great....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@carlosdanielriosvillarreal1872]

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

[@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?

[@DilipTiwariVlogs]

Awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RadheRadhe-ln6sw]

How can we add Drill Up option below of Total sales instead of right click? Also, can we attached summary tiles and grid/table which will also changes according to drill down and drill up on pie chart?

[@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

[@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

[@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.

[@arindambhattacharya8127]

Can I drill through two charts simultaneously in Power Pivot?

[@ansumanmohanty4761]

Can we create drill down column chart under pie chart?

[@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

[@arindambhattacharya7848]

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

[@mohamadfawaz1928]

wow

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aquamarine76]

AJDE GENI kAMENI

[@aquamarine76]

THOMPSONE KRALINO!!!!!