The Secrets of Drillthrough in Power BI

This video shows you how to use drillthrough in Power BI. It allows you to easily navigate to the details of a datapoint. Very useful if you want to analyze very detailled data.
Master Functions and Syntax in M
powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: paypal.me/rickmaurinus.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
kzbin.info?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
00:00 Introduction
00:49 Drillthrough explanation
02:23 Setting up Drillthrough
03:34 Drillthrough with a Column
07:14 Drillthrough with a Measure
08:30 Improve user-experience of drillthrough
#drillthrough #powerbi #bigorilla

[@ravchana2393]

Great video - love the default / actions prompts on the button functions. Thanks 👏

[@GPZ_Biker]

Great video, very clearly explained and easy to follow. Thanks

[@amberdavis1079]

This was so easy to understand. I've been struggling with the drill through process & now I get it!

[@nelsonlopes9518]

thank you for taking the time to produce this video. Very, very helpful

[@allanramirez266]

That details button is very lit. very well explained. Thank you

[@StephenVail]

Best video I've seen explaining drill through and I could actually understand every word.

[@syedzyad4328]

Best video on Drill through

[@olga6459]

Amazingly clear explanation, thank you so much! The details button is a great new thing for me. Thanks again!

[@pravinshah8297]

This was of great use to me. Very well explained and foundations of the methods covered

[@AuroraS934]

Clear explanation, good examples, thank you! I favor the "Details" button, it's more user friendly than the right-click, it's visible and less clicks however takes from real-estate so each solution has it's own use.

[@mnowako]

Amazing! Well explained. I have already started working on that and the video came out. Subject lerned. Thank you! 👏

[@BIGorilla]

Mariusz, thanks for the kind words. I love how you've been binging through my videos. More content coming up the coming weeks 😁

[@kuldar.]

Amazingly well explained! Thank you, Sir!

[@NearbyCactus]

That's a great explainer, and very timely too! Love the use of the details button.

[@BIGorilla]

Thank Tim. It's an essential functionality in most of my reports. Hope from now on in your reports too!

[@DamianWebber]

Yes, the details button is very useful. I shall pass that on to my team 🙂

Awesome video Rick! Especially that part about the button, that was new for me and very useful. Thanks!

[@BIGorilla]

Thanks 🙏 the buttons are great fun. I only showed the default state and the disabled. The on hover is also pretty useful. That one works when you hover and the drill through state is on. Next week other interesting features on drillthrough. Already scheduled 👏

[@dxwell99]

Thanks very much, good clear communication.

[@augustotanaka]

Easy and straight to the pointm thanks

[@Soulenergy31]

Thank you Guru!!!! and congrats on the MVP!, the method 08:46

[@mohammadazadi3616]

Perfect tutorial.thank you

[@dharmendars8483]

I knew about Drillthrough but adding Measure and Button to it...wow this trick is so much useful in my visual.. Thanks bro for the tips...

[@BIGorilla]

Fantastic! Next week a follow up on drillthrough is scheduled. You're gonna love it!

[@felipesignorellireis7839]

Great tip about the button

[@dhirajr3376]

Tnx man perfect step by step

[@gauthama4092]

Great video. Learnt a Lot

[@plteow1884]

Great tips..thanks!

[@supersayan9888]

Can you drill trough within a current page? Let say I have a productcategory that I selected and a bar chart that has both productcategory and product subcategory. I want powerBI to automatically zoom in on the subcategory once I select a product category. Possible?

[@robderrt]

Very good video.

[@Alpacastan21m]

In method 1, is there a way to select multiple colors and thus have the drill through page show the sales amounts for both Red and Blue (for example)? Or all colors for that matter for a given year?

[@RK-ct6mn]

Hi, I'm trying to drill through by row headers but that option isn't working. The drill through is working only when we click on the values. For example, in your viz I would like to drill through all the blacks not by years...any work around for this?

[@ranapratap4756]

nice

[@shirleympearls]

I know I'm late to this game but I'll take the long shot - so I have a measure that is a calculated % value. Now I'm trying to use it to drill through to see the records against the numerator used in the measure calculation. How do I achieve this?

[@DamianWebber]

Very clear video. A quick question on the topic of drill down. Can I load a hierarchy of a drill down table (or chart) at a specific level depending on another contextual factor (such as permission). EG. I am a regional salesman and want to the corporate sales dashboard to open at the level of my region - rather than all regions? Thanks

[@BIGorilla]

Hey damian. You can do exactly that with Row Level Security. Which prefilters your datamodel depending on your role. Regards, Rick

[@DamianWebber]

@@BIGorilla Ah, If I have hierarchy of Global > Country > State and I want my State Sales Manager to see State when first opening the dashboard that does not work. It will show him 'rolled-up' values but the dashboard shows Global (with his total sales), then drill down to Country (with his total sales), then drill down once more to see his own state. The data is secured with RLS but the experience could be better.

[@DamianWebber]

@@BIGorilla Maybe I create three separate visuals and create another layer of security showing "top level' (State, Country, Global). Each visual has a different hierarchy...?

[@natsarev]

Is it possible to keep color filter and to remove Date filter when drilling through? Ex. When I drill through choosing Red and 2012, I want to see sales of Reg but all years, not only 2012. Thank you.

[@BIGorilla]

Hi, That's very specific. I believe you can do that. But since the filter context of the original visual is copied including the date filter. You would need a measure in the drill through table that ignores the year using REMOVEFILTERS() or ALL() Hope that helps!

[@natsarev]

@@BIGorilla need to try that but not sure it will work, or maybe I got you wrong. Would be great If you demonstrate this case in future videos cause I failed to find any info.

[@decemberflower20]

Let me ask one thing. Drill through function is able to use in calculated table?

[@BIGorilla]

Drillthrough works with visuals and pages. Not with calculated tables

[@pandianselvaraj9204]

How to set slicer from month and to month? Start month. End month 2021-01. (text) 2021-02 Please guide me.

[@BIGorilla]

Hi, I don't understand your requirement. To have your question answered quickly, please describe your case more elaborately. Thanks Rick

[@BIGorilla]

@UCihxxY6njzF0t4A_te2GgVw this seems very off topic to this video. Please only comment on topics relevant to the video. Ps. Your requirements are not clear to me in the post. For private consulting please reach out through [e-mail] Thanks, Rick

[@pablodestefanis]

Very annoying music

[@BIGorilla]

Noted, no more music xD