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

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

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

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

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

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

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

Best video on Drill through

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

@BIGorilla

2 жыл бұрын

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

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

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.

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

@BIGorilla

2 жыл бұрын

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

@DamianWebber

2 жыл бұрын

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

2 жыл бұрын

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 👏

Amazingly well explained! Thank you, Sir!

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

2 жыл бұрын

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

Easy and straight to the pointm thanks

Thanks very much, good clear communication.

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

Perfect tutorial.thank you

Very good video.

Tnx man perfect step by step

Great tip about the button

Great video. Learnt a Lot

Great tips..thanks!

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?

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?

nice

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?

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

2 жыл бұрын

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

@DamianWebber

2 жыл бұрын

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

2 жыл бұрын

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

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

2 жыл бұрын

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

2 жыл бұрын

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

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?

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

@BIGorilla

5 ай бұрын

Drillthrough works with visuals and pages. Not with calculated tables

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

@BIGorilla

2 жыл бұрын

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

@BIGorilla

2 жыл бұрын

@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 rick@gorilla.bi Thanks, Rick

Very annoying music

@BIGorilla

11 ай бұрын

Noted, no more music xD