DRILLDOWN and DRILLTHROUGH in Power BI - Taking it to the NEXT LEVEL
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- Learn how to use drilldown and drillthrough in Power BI. Take you visualizations to the next level!
Download file here datatraining.i...
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatrainin...
Power BI Essentials datatraining.i...
Business User Training datatraining.i...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
😍 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.ne...
Newsletter datatraining.i...
---------------------------------
👇 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.epidemicso...
🚀 For growing on TH-cam: www.tubebuddy....
🏄 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
Extremely well done. All aspect of drill down, up, ... and drill through were well explained. Thanks so much for sharing this video.
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
Easily the best power bi tutorials in TH-cam. They’re crazy good.
Great video. Very very explicit. Thanks so much for this. Looking forward to more amazing content
Thank you! More to come!😀
I've finally I learned what that Drillthrough button is for. Thanks a lot. Great explanation
thank you!
This is the best what I have seen so far
I have to say I am loving your videos!
Thanks Matias!
Brill !!
Lot of concepts in one video ..
Thanks 👍
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.
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?
Should we enable drill through in the details page visual or in the main page visuals for this to work??
Details
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?
You are the MASTER-DRILLER dude! Thank you very much! :D
Hahahah thanks?!!! ;)
Is it possible to use drilldown for the legend in a line chart?
Great video!
Really good vid. Thank you. Subscribed.
awesome, Thanks for the sub Bhim! 😀
Thank you very much for the video
It was easy to grasp
Glad to hear that Anam!
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?
I should have watched this video WAY earlier! Excellent explanation :)
Thanks man. Can we drill through a table entry?
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?
This is really good. I have been looking for this information. You explained it in very detail and in easy way. Thanks a lot
Excellent Explanation about this feature.
Samantha, I am glad it was helpful! :)
Powerful stuff. 1st video was June 2020 yet so impressive. We will be following this channel closely. Where have you been?
doing my best :D , happy to hear you like it! more powerful stuff coming ;)
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?
Wow!! So simple and insightful
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
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 ?
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: th-cam.com/video/x64KFTbk4Yc/w-d-xo.html
Thank you 😊😊
You are welcome 🤗:)
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
is it possible that drill thorough can do by bookmark navigation? like if we show subcategory in table and Infront of each table there should be some bookmark and click on that take u to respective project?
Thank you. Do you know how can we move the drill down and drill up icons? It is always on the top but i want to move it.
Great video. You have covered up all the important features related to Drill down and Drill through. Thanks! 🔥
happy to hear 😀 thanks!
when I drill down, am i able to regroup the data by month? e.g. Jan of 05/06 showing side by side?
Thank you for the demo! :)
Thx for watching
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
thanks for the sub and welcome to our channel!
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
Hello Bas, question for you. How do I create a drill through from a bar chart (yr-mth from date table with measures from main table) to a detail page that filters the details page based on the bar selection. My issue is that the numbers are off for all months except January.
U r awesome man... Thank you
Please create a video on how to do Hyperlink drill through, mean that we will no need to right click and drill through
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?
yes, just place the dimensions on the visual (for example all on rows in a matrix) and you can drill / expand down.
Thanks. The creation of product hierarchy is a bomb for me. I love it. More grease
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)
@@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
This is great, thanks for the great content!
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 :)
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
@@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 .
@jamie, were you able to find a solution for this ..
Very well explained.
thank you!!! 😁
Great information..Thank you..please upload more videos..
thank you! definitely will :)
Very clear! Thanks
thx for watching Fra 🙂
My new Fav channel
thank you so much Kátia, happy to hear!!! 😀😊
Excellent content... Thank you so much, this is quite useful!!
so nice to hear, thank you!😀
Where is the data csv being used?
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
Can you make a video of how to create your reset all filters (the icon you have on this report) Thanks in advance!
already have it 😁 th-cam.com/video/_HTF7Ph7Eqc/w-d-xo.html .. min 3:02 ...
@@HowtoPowerBI you are the man !
Best explanation ever! Thank you for this. 🙂
thank you Melanie! 😀
Excellent video. I was wondering if there is a way to drill through cross reports using a button rather than having to right click?
Here you go
th-cam.com/video/I7oyyb0Y8Oo/w-d-xo.html
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 ?
Awesome video
Can u do video on powerbi service
Yes, it is on my list 🙂
Good one
thx Smeet!
Good job, I have a request, could increase subject screen and reduce yours? Thanks ;)
Thanks Normand 😊 . Considered it, but will be sticking with this format for now
How do you drill trough from a slicer :), the bar chart cannot go to the next level in a hirarchy. Correct?
Yes. Great. Thanks a lot
happy to hear it was helpful :) Let us know if you have any questions or requests for upcoming videos
Thanks
Great explanation!
thanks! :D
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
thx for pointing it out! should be fixed now! 🙂
Good explanation
Thx Praveen!!! 😀
Great content and very useful👍Thanks!
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.
Hi Jane, that's what happens when you turn drilldown on,.. no? 🙄
@@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 :)
How do you clear the drill-down, go back up without using the arrow
you could create a bookmark and use that .. not sure why you would want it though
@@HowtoPowerBI thanks for the reply. I created a clear all button using book marks
excellent
Thanks Mihaela
I am unable to drill through using year field
Great video. But why ad music to make it more difficult to understand what you are saying?
great
Right Click on any bar and you can Drill down
Thanks -
you are welcome George!
but you don't show how to add this drill down button,
thank q
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?
haha this is already my favorite comment of the year 🤗😀 .. of course bas.dohmen@datatraining.io
Good explanation! Thank you. But, I gotta say, the drill at the beginning was Hee Haw level of corny :)
👏🏻👏🏻
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.
don't see how this is quick .. just set speed to 0.5x
Weapons shouldn't be shown on this...oh wait... OK, you're good.
hahaha :)
First of al your excel is weid af! so it didnt help with the lay out
😂that's because it is power bi not excel lol
unclear
Why?
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