How to use Drill Through in Power BI. 👆 ONE click from chart to details

The Power BI drill-through feature is an easy way to provide a more detailed view of your data. Afterall, it's always good to be prepared when you're presenting your data. Power BI Drillthrough is super easy to implement. You just need the right start. In this video I'll show you how to set up drill through in Power BI desktop.
You can also add a button to click on to drill-through to the details. Remember, in Power BI Desktop you have to use control+click but in PowerBI service, you just need to click. A back image icon is also automatically added to your drillthrough page which then takes you back to your original page. You can have multiple drill-through pages as well. That's great if you want to add different views of the data or if you can't decide what your audience might want.

00:00 Drillthrough in Power BI
01:11 How to Setup a Drill Through Page
06:20 How to Setup Multiple Drill Through Pages
07:04 Add a Button for Drill Through
09:17 Wrap Up
09:56 Get the Complete Power BI Course

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[canirmalchoudhary]

Though I don't use Power BI in daily job but learning this drill-through functionality is master tip

[noruwajoshua]

I never understood Drill Through like this before. Thank You!

[FadliBKL]

Congratulations Leila.
You have make my life easier. I am progressing with you since excel 👏🏻👏🏻👏🏻👌🏼 thank you…

[woljin]

I love how you say "let me show you". This does take an effort to predict operations needs but overall I love this tutorial. I have not really used the drill through options in power bi but I have added links to details pages in a similar fashion. I think this method will improve my methodology. Thank you so much for the insight and keep up these videos. You really have your finger on the pulse of what operations will desire from these tools and explain it very well. Love the videos! 😊

[Ocram-gnuhc]

Thanks so much. So detail and easy to follow. I learnt drill through finally!❤

[GodGladiator]

your videos on excel and on power Bi have helped so much thank you!

[adlaalnajmi]

I am only 5% through the BI course, and I started building reports. This is great

[vijayarjunwadkar]

Hi Leila, I am learning these features through your Power BI course, but still enjoying these videos as well! Thank you! And congratulations on getting 2M+ subscribers! Way to go, all the best! 😊👍

[davidvieira]

Hi Leila, I've been following your amazing work for some time now and it has been very important to me.
That said, and regarding this topic (drill through) I would like to ask a question:
I have found drill through examples only with charts, however I wonder if it applies to tables? i.e. I have a table of summaries (e.g. order forms) but I would like to see more details (the respective articles) by drilling through.
I hope you can help me.
Thank you!

[lolosan]

Hello Leila, thank you so much for the bonus tip. 😀

[arbazahmad]

Thanks for this Drill through features of Powerbi...

[StopWhining]

Moves along fast for a beginner, not the speed so much as what user needs to know before viewing. Good info, through, for an intermediate level user.

[chrism]

This was great thanks Leila and congrats on hitting 2MM!

[MrMumumumu]

Hey Leila, thanks for the useful video. Can you please elaborate on how to undo the drilltrough-filters on the drillthrough-page? In your example, if you wanted to undo your store selection, you would have to do it by removing the filter in the visualizations-pane, right? Is there an option to do this more user-friendly via a button?

[meredithleonor]

thanks for sharing looking forward for more power bi tutorials

[chh]

'Thursdays With Leila' back again! ... 👏👏👏 ...

Leila's P-BI "appetizers" are tempting ... but not so good for someone with ADHD, i.e. "OMG ... look at THIS! ... Oh WOW!!! I can do THAT? ... OH, what's that for? ...COOL!!! ... VERY COOL!!! ... OMG, look over HERE!!!! ...". I salivate at the thought of the full meal (i.e. P-BI course), but alas it will be a while before I can sit at the table and focus ...😟 ... but when I do, I now know there will be a 'piece of cake' along with the meal ... 😋.

Thank you ... thank you .... thank you ... 😍 ...😍 ... 😍

[hassansafieddine]

Hi Leila, great work as always, can you make a video of how to add offline maps, and add coordinates to these maps... Thank you

[sserubiricedrick]

Thank you so much for the good work, we really appreciate it.
Kindly create for us Introduction to python"lessons as well.

[rickyzeng]

Share for sharing, very clear explanation.

[samniengpollong]

Always very useful and helpful. Thank you so much....