The Secrets of Drillthrough in Power BI

[@allanramirez266]

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

[@olga6459]

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

[@nelsonlopes9518]

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

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

[@syedzyad4328]

Best video on Drill through

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

[@StephenVail]

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

[@amberdavis1079]

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

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

[@ravchana2393]

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

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 👏

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

[@GPZ_Biker]

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

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

[@felipesignorellireis7839]

Great tip about the button

[@augustotanaka]

Easy and straight to the pointm thanks

[@kuldar.]

Amazingly well explained! Thank you, Sir!

[@mohammadazadi3616]

Perfect tutorial.thank you

[@dxwell99]

Thanks very much, good clear communication.

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

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

[@dhirajr3376]

Tnx man perfect step by step

[@Soulenergy31]

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

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

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

[@gauthama4092]

Great video. Learnt a Lot

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

[@robderrt]

Very good video.

[@december_randoms]

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

[@kentlewan]

I could not get the button to work until I watched a different video and deleted and recreated the button. You have to CNTRL + CLICK. Not just click. Why? The Drill Thru from the charts did work quite nicely however. Thank you.

[@plteow1884]

Great tips..thanks!

[@ranapratap4756]

nice

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