DRILLDOWN and DRILLTHROUGH in Power BI - Taking it to the NEXT LEVEL

Learn how to use drilldown and drillthrough in Power BI. Take you visualizations to the next level!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZbin: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[@williamharper9948]

Extremely well done. All aspect of drill down, up, ... and drill through were well explained. Thanks so much for sharing this video.

[@kookooiam6034]

thank you for explaining this so well, other channels skim over the details and only show a portion of what each function can do... you explain each function of the subject in great detail giving many different examples... I am so thankful for your videos

[@rschloch]

Easily the best power bi tutorials in KZbin. They’re crazy good.

[@ivannakoniukh3855]

This is the best what I have seen so far

[@vamsiharati3206]

Brill !! Lot of concepts in one video .. Thanks 👍

[@nonoobott8602]

Great video. Very very explicit. Thanks so much for this. Looking forward to more amazing content

[@HowtoPowerBI]

Thank you! More to come!😀

[@salehmuhammad6811]

Masha Allah how good is that to interpret and explain. Good bro may Allah give success to your effort & Allah bless for next amazing contents.

[@shraddhapatil7963]

This is really good. I have been looking for this information. You explained it in very detail and in easy way. Thanks a lot

[@TrassBI]

Great content and very useful👍Thanks!

[@shabnamkhan7235]

This is great, thanks for the great content!

[@Sipbykarey]

Wow!! So simple and insightful

[@kishore_p93]

Great video. You have covered up all the important features related to Drill down and Drill through. Thanks! 🔥

[@HowtoPowerBI]

happy to hear 😀 thanks!

[@marufibragimov2579]

I've finally I learned what that Drillthrough button is for. Thanks a lot. Great explanation

[@HowtoPowerBI]

thank you!

[@MelanieM63]

Best explanation ever! Thank you for this. 🙂

[@HowtoPowerBI]

thank you Melanie! 😀

[@cyrilzyriacjoseph1961]

Thank you 😊😊

[@HowtoPowerBI]

You are welcome 🤗:)

[@rajprabu6040]

U r awesome man... Thank you

[@ramyessam8537]

Thanks for your great explanation .. I have one question: After drilling through a certian dimension and go to the drill through page, can I change the filter context while being in the drill through page? I have a trend line chart at the drill through page, if I come from the main page while selecting November month for ex, I want afterward to see other months trends as well

[@framusk5585]

Very clear! Thanks

[@HowtoPowerBI]

thx for watching Fra 🙂

[@guusvanzuylen6501]

Excellent and enthousiastic explanation! I do a drill through from a table to a detail table, after that I return to my original table. I forgot from which line I did the drill through. I there a way to highlite this line?

[@McGregor2688]

Excellent content... Thank you so much, this is quite useful!!

[@HowtoPowerBI]

so nice to hear, thank you!😀

[@Mardop1]

You are the MASTER-DRILLER dude! Thank you very much! :D

[@HowtoPowerBI]

Hahahah thanks?!!! ;)

[@Xevailo]

I should have watched this video WAY earlier! Excellent explanation :)

[@matiasmey5477]

I have to say I am loving your videos!

[@HowtoPowerBI]

Thanks Matias!

[@anamqureshi802]

Thank you very much for the video It was easy to grasp

[@HowtoPowerBI]

Glad to hear that Anam!

[@EricaDyson]

Yes. Great. Thanks a lot

[@HowtoPowerBI]

happy to hear it was helpful :) Let us know if you have any questions or requests for upcoming videos

[@vishnupp5944]

Thanks

[@samanthapikus3178]

Excellent Explanation about this feature.

[@HowtoPowerBI]

Samantha, I am glad it was helpful! :)

[@arinbose5778]

Thank you so much. Love from India. Can you teach on how to find the top 3 items each year or things like that and drill down on those 3 items?

[@louism.4980]

Thank you for the demo! :)

[@HowtoPowerBI]

Thx for watching

[@kongklas]

I like going back to the basics now and then, completely re-learning basic operations as well as being reminded how crap the sound used to be :P

[@bhimpujar8639]

Really good vid. Thank you. Subscribed.

[@HowtoPowerBI]

awesome, Thanks for the sub Bhim! 😀

[@AbdullahJan-nv1qd]

Thanks man. Can we drill through a table entry?

[@katiamutombene2210]

My new Fav channel

[@HowtoPowerBI]

thank you so much Kátia, happy to hear!!! 😀😊

[@eyitayoeyitayo-lawal2331]

Thanks. The creation of product hierarchy is a bomb for me. I love it. More grease

[@HowtoPowerBI]

hierarchies give that finishing touch :) , I would usually set them up and hide the original fields. Many uses cases (for example also for locations -> country, state, city)

[@eyitayoeyitayo-lawal2331]

@@HowtoPowerBI I was excited to put it to use at work this morning and I was blown out to see that it's just a drag and drop away. A drill down combo Pro by ZoomCharts put icing on the cake. Thank you for replying my mail. I feel honoured. Cheers

[@totvabe1]

Great explanation!

[@HowtoPowerBI]

thanks! :D

[@vishnurao2901]

Great information..Thank you..please upload more videos..

[@HowtoPowerBI]

thank you! definitely will :)

[@mihaelamironescu9736]

excellent

[@HowtoPowerBI]

Thanks Mihaela

[@vinayak254]

great

[@bananageorge2133]

Thanks -

[@HowtoPowerBI]

you are welcome George!

[@rajivchoudhary3148]

thank q

[@CanonCrested]

This is really good. Got referenced here by Guy in the Cube. Love how we can see the visualization you are working on. Subscribed. Looking forward to the next video

[@HowtoPowerBI]

thanks for the sub and welcome to our channel!

[@hildeverschooten5115]

Thank you! One problem I come across when drilling down is that it doesn't keep my gradient colours as I set for the top level (red for highest value and green for lowest value). When I drill down I want to keep this gradient colours. How do I manage that?

[@user-dh6wx3fe6y]

Thanks for the video! I’m only wondering how to keep the state of the visualization after clicking Back button from the drill through page?

[@monicajain2315]

Thankyou for the insightful video. Can you please help on how to sync hierarchy in two visualization. I have one revenue graph and another cost graph with same hierarchy (H1

[@Mamaditalia]

Very well explained.

[@HowtoPowerBI]

thank you!!! 😁

[@Smeetr]

Good one

[@HowtoPowerBI]

thx Smeet!

[@abrammakgalemele3491]

Powerful stuff. 1st video was June 2020 yet so impressive. We will be following this channel closely. Where have you been?

[@HowtoPowerBI]

doing my best :D , happy to hear you like it! more powerful stuff coming ;)

[@davidpuddicombe7946]

Is it possible to use drilldown for the legend in a line chart? Great video!

[@jhewitthunt]

liked that. Very well explained. Be nice if there could be a little button on each tile, so that could be clicked to Drill through rather than having to right click. That way, you could click most places on the tile so it changed the data elsewhere on that page, or click the little button so it went to the extra details page :)

[@HowtoPowerBI]

That would be cool! although I think if you turn on the drillthrough button from the ribbon goes into that direction. Then you can just left click

[@whdea3426]

@@HowtoPowerBI yes , but that is a per session thing, it vanishes out even the report . Also at the service it can be enabled from explore option , but it then cannot be saved and is a per session thing. Thanks again , You always make awesome vidos .

[@whdea3426]

@jamie, were you able to find a solution for this ..

[@praveensebastian2107]

Good explanation

[@HowtoPowerBI]

Thx Praveen!!! 😀

[@balaswamy3779]

Hi, can you clarify me the below issues which i faced in Real time. 1. I have created Clustered column chart or it could be any other chart which is having drill down Options. then i click the option " Click to Turn on Drill Down " Option and seen respected data. after sometime the report published in to cloud. here i don't want to select again which i selected earlier like " Click to Turn on Drill Down " Option. Is there any solution for not resetting that option once i published into cloud ? 2. Is it Possible create Drill Through Option in Same Page ?

[@bobthedruid9378]

when I drill down, am i able to regroup the data by month? e.g. Jan of 05/06 showing side by side?

[@anupajayakody458]

Should we enable drill through in the details page visual or in the main page visuals for this to work??

[@HowtoPowerBI]

Details

[@barttitulaerexcelbart9400]

Very very good explained. First time I have been here, by coincident. One question: why was your last (not full) year green as opposed to the other years (blue)? You started from scratch and I did not see you format anything ?

[@HowtoPowerBI]

thanks Bart! I applied conditional formatting, which was not shown in the video to not distract from the main topic. The explanation on how it was done you can find here: kzbin.info/www/bejne/rmeXfHmKl9Bnj8U

[@iqrarkhan8129]

Please create a video on how to do Hyperlink drill through, mean that we will no need to right click and drill through

[@nostromo3986]

Drilldown is linked from one graph to another on the same page, but not "go to the next level in the hierarchy" and expand all down one level in the hierarchy. Can that be done?

[@MrTejasreddy]

Awesome video Can u do video on powerbi service

[@HowtoPowerBI]

Yes, it is on my list 🙂

[@PowerBiTutorials]

👏🏻👏🏻

[@carax006]

Thank you for all your videos! Very useful! There is an issue about the download of this file,can you sort it out? Thank you

[@HowtoPowerBI]

thx for pointing it out! should be fixed now! 🙂

[@Hariharan-eb4os]

is it possible in Power BI, when you view your main report and click on a row or data point in the specified visual, Power BI will navigate to the drill-through page

[@bravucod]

Can you make a video of how to create your reset all filters (the icon you have on this report) Thanks in advance!

[@HowtoPowerBI]

already have it 😁 kzbin.info/www/bejne/lXm3d2qGnZx4p8U .. min 3:02 ...

[@bravucod]

@@HowtoPowerBI you are the man !

[@BarryRussell2]

Right Click on any bar and you can Drill down

[@normandtousignant1754]

Good job, I have a request, could increase subject screen and reduce yours? Thanks ;)

[@HowtoPowerBI]

Thanks Normand 😊 . Considered it, but will be sticking with this format for now

[@QasimAli-gy3nb]

Can we make combination of dimension in drill down like I wanna see my sale over time but wanna see who(customer) a caused that dip in my sale, i.e date and customer. On top of that I also wanna see what product do they buy. In nutshell I want drill down these three dimensions. Is it possible?

[@HowtoPowerBI]

yes, just place the dimensions on the visual (for example all on rows in a matrix) and you can drill / expand down.

[@janetan864]

Hi there! Is there a way to show your drill down data automatically? Like for example, if you click onto year 2020, it should show you the next level hierarchy by default.

[@HowtoPowerBI]

Hi Jane, that's what happens when you turn drilldown on,.. no? 🙄

[@janetan864]

@@HowtoPowerBI Hi, currently I understand that users will have to right-click to drill through or click on another the drill down button to view the data. Was just wondering if there is a way to show data automatically after clicking on a data point. Based on my research, it's not possible but I have managed to build a drill through button to help users navigate the report better :)

[@supersayan9888]

How do you drill trough from a slicer :), the bar chart cannot go to the next level in a hirarchy. Correct?

[@davidredman8926]

Excellent video. I was wondering if there is a way to drill through cross reports using a button rather than having to right click?

[@HowtoPowerBI]

Here you go kzbin.info/www/bejne/f2jSqqyYZb5rhdE

[@OriginalBernieBro]

Where is the data csv being used?

[@joefromdc]

How do you clear the drill-down, go back up without using the arrow

[@HowtoPowerBI]

you could create a bookmark and use that .. not sure why you would want it though

[@joefromdc]

@@HowtoPowerBI thanks for the reply. I created a clear all button using book marks

[@karinbeyaert9950]

Great video. But why ad music to make it more difficult to understand what you are saying?

[@Wzxxx]

Well ok, I tried it by I can’t figure out one simple thing. I would like to select 2 categories from a one piechart (ie. phone and screena) on one page and then use drill to go on a details page. I can’t. If I select these 2 categories and any other in anothet chart - it works. It keeps 2 caegories from one chart and one from other chart so I can use drill through. But…i can’t select 2 categories on one chart and drill. Please don’t tell me that MS did not take this into account. It is absolutely out of any sense

[@rewinwilson6021]

Im not gay but id still marry you becoz your videos are simply awesome. Its amazing how you take us through power bi and it it always amazes me how well thought power bi is....great video buddy and really great explanation...youve touched on the bare minimum which makes the most impact..... Please dont stop.....Is there a way i can reach out to you if i need help on power bi?

[@HowtoPowerBI]

haha this is already my favorite comment of the year 🤗😀 .. of course [e-mail]

[@DeronHuskey]

Good explanation! Thank you. But, I gotta say, the drill at the beginning was Hee Haw level of corny :)

[@CaucasianEU]

but you don't show how to add this drill down button,

[@Phoenixspin]

Weapons shouldn't be shown on this...oh wait... OK, you're good.

[@HowtoPowerBI]

hahaha :)

[@the_Brus]

Why are You hiding details so quickly? [0:56] have pick of users checking this, not becouse it is very hard, but it was hidden to quickly.

[@HowtoPowerBI]

don't see how this is quick .. just set speed to 0.5x

[@markwhite168]

unclear

[@HowtoPowerBI]

Why?

[@deborahmadimba577]

First of al your excel is weid af! so it didnt help with the lay out

[@HowtoPowerBI]

😂that's because it is power bi not excel lol