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 👏
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.
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?
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 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.
@@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...?
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?
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?
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?
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.
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!
@@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.
@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
thank you for taking the time to produce this video. Very, very helpful
Amazing! Well explained. I have already started working on that and the video came out. Subject lerned. Thank you! 👏
Mariusz, thanks for the kind words. I love how you've been binging through my videos. More content coming up the coming weeks 😁
That details button is very lit. very well explained. Thank you
Best video I've seen explaining drill through and I could actually understand every word.
That's a great explainer, and very timely too! Love the use of the details button.
Thank Tim. It's an essential functionality in most of my reports. Hope from now on in your reports too!
Yes, the details button is very useful. I shall pass that on to my team 🙂
Best video on Drill through
This was so easy to understand. I've been struggling with the drill through process & now I get it!
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...
Fantastic! Next week a follow up on drillthrough is scheduled. You're gonna love it!
Great video - love the default / actions prompts on the button functions. Thanks
👏
Great video, very clearly explained and easy to follow. Thanks
Awesome video Rick! Especially that part about the button, that was new for me and very useful. Thanks!
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 👏
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.
This was of great use to me. Very well explained and foundations of the methods covered
Easy and straight to the pointm thanks
Thanks very much, good clear communication.
Great tip about the button
Amazingly well explained! Thank you, Sir!
Thank you Guru!!!! and congrats on the MVP!, the method 08:46
Perfect tutorial.thank you
Tnx man perfect step by step
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?
Very good video.
Great video. Learnt a Lot
Great tips..thanks!
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
Hey damian. You can do exactly that with Row Level Security. Which prefilters your datamodel depending on your role.
Regards,
Rick
@@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.
@@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...?
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?
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?
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?
Let me ask one thing. Drill through function is able to use in calculated table?
Drillthrough works with visuals and pages. Not with calculated tables
Amazingly clear explanation, thank you so much! The details button is a great new thing for me. Thanks again!
nice
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.
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!
@@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.
How to set slicer from month and to month?
Start month. End month
2021-01. (text) 2021-02
Please guide me.
Hi,
I don't understand your requirement. To have your question answered quickly, please describe your case more elaborately.
Thanks
Rick
@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
Noted, no more music xD