DRRR... DRRR... DRILL BUTTON | How to set conditional DRILL THROUGH destinations

[@usamabinnasar]

This is now the third time I have come looking for something on this channel and found Exactly what I was looking for. Keep doing the Good work.

[@pupycron4302]

You explained this SO well. I never felt lost or confused. Nice work!

[@HowtoPowerBI]

I am so happy to hear this! thank you :)

[@theraynman397]

You do a good job on your videos. I appreciate when you start at a base value and then build on to it. Thanks for your work.

[@tauraik]

One of the best tutorials I've seen well done. Well explained and very clear

[@onyxj589]

This tutorial is absolutely amazing. Very helpful

[@evv5891]

This was excellent! Thank you so much! Very clear and concise!

[@graemegourlay2850]

Great tip with the drill button. Just implemented it. In the latest visualizations menu it's now called "Text" rather than "Button Text". All works.

[@HowtoPowerBI]

Thanks for letting me know!

[@FernandoFrenkel]

Very good, very complete, also perfectly edited, thank you very much

[@HowtoPowerBI]

Glad you liked it Fernando! :) more is still to come!

[@workstuff5253]

Another fantastic video Bas! Thank you.

[@HowtoPowerBI]

thanks again for watching!! 😀

[@ahmadhassanbakr]

You are the best. I was looking for a way to enable the drill through button on multiple selections from visuals, as without conditional setting, the button gets disabled. You naled it. Kudos! I have an elaboration: I wanted to enable multiple selections from all visuals and still get the button work. I added a dummy visual (pie chart, and made it very small like a dot) and created its drill through page (exaclty like the other drill through page) and added in the tooltip for the user if the button is not enabled, click the dot. It worked :)

[@sethpark2539]

You have so many creative ideas! Thanks for sharing.

[@HowtoPowerBI]

Thank you Seth! 😊

[@jhewitthunt]

quite advanced stuff there, but very well explained. Thanks very much!

[@sivamagesh]

Your videos are very clear and helpful

[@rameshkandi]

wow.. brilliant explanation... I learn so much from your channel.

[@HowtoPowerBI]

Awesome! thanks for watching Ramesh!

[@bravucod]

Great tutorial!

[@HowtoPowerBI]

thx Daniel!!!! 😀

[@youjohnny16]

3:29 is awesome method for interactive button text for drill through

[@gaborbereczki6484]

Super useful, thanks for sharing!

[@HowtoPowerBI]

Glad it was helpful! thx Gabor! 😀

[@satyakanungo4176]

Thank you my Teacher

[@MrAszpic]

100% complete, thanks a lot for sharing!

[@MaurizioFaini]

Ehi, great video! Thanks so much Bas!

[@HowtoPowerBI]

thx for watching Maurizio!

[@TrassBI]

Very helpful knowledge. Thanks for sharing!👍

[@HowtoPowerBI]

Glad it was helpful Trass! thx for watching! 😀

[@tubeitz]

So good, thank you

[@HowtoPowerBI]

Thanks Varun!

[@totvabe1]

Very useful, Bas!

[@williamviegas]

Thanks for sharing!

[@HowtoPowerBI]

thanks for watching William 😊

[@lemianelson2012]

This is amazing 👏🏾

[@HowtoPowerBI]

thx Nelson!!! 😃

[@northernboy70]

Just found your channel, great content, clearly presented. Thank you very much 🙂

[@HowtoPowerBI]

Thanks for watching and your kind words Peter! More content is coming soon :):)

[@Vicky_s16]

This was really an amazing explanation . But is there a way to have it conditional while using right click to drill through ?

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

[@alfonsogordillo9900]

Excellent video thanks a lot, how I can use the text in a table as a link in order to go to drill trough screen ?

[@roscaacinitram3058]

Gracias hermano por tus tutoriales eres un "fenómeno". Pero como harías combinando y condicionando un drill through con un para parámetro de campo?.

[@chengwang411]

The most good looking PBI instructor 🤣

[@jyotidatta2126]

Informative. I have a situation for drill through. When I drill through on 1st page, it should takes me to another page and show only one Gantt chart (out of the two overlapped one) as per the criteria selected. Can you pls advise soon?

[@javedkhan-tz6fn]

Awesome... Buss could you help me how do you create these videos

[@HowtoPowerBI]

hi Javed, good microphone, decent camera and loads and loads of editing :)

[@ymohamed3154]

Amazing👌👏👏

[@HowtoPowerBI]

Thanks 🙏

[@rajeshtatineni85]

hi, nice video, can you look in to this? i have a matrix table and user want to navigate to diff pages depending on user selection. Say, button should enable if user select only A and navigated to desired page. if user selected other than A it shouldn't enable and say pls click only A. Can u help me on this?

[@100SAYWATNOW]

Does drill through pick filters passed inside calculated measures? I am working on a report that measures are disappearing.

[@johanynavarro8065]

Great video legend!!! keep it up... A quick question.... How to filter by blank dates in PowerBI??

[@shruthil7913]

Thanks for sharing ..:-) Option 2 I don't see it is applicable for tables. for bar charts it works.

[@joelgonzales720]

Do you know why the button text measure is grayed out for me on the conditional formatting screen?

[@Bharath_PBI]

Thank you. Destination set-up won't work when the report is in live connection to any published dataset. Any thoughts here?

[@dlam8276]

Hi how can I make a button drill through with a measure on a card. I am able to right click and drill through but I like to make a button to drill thru instead.

[@Theozzie11]

Can the button already be selected/defaulted when a page is entered. Instead of clicking twice, only click on the button?

[@kostaszogopoulos1719]

GRRRR..GRRRR...GREAT video as always Bas! But you know that we are here to challenge you. Is there a way we can move directly from one drill-through page to the other without having to go back to the main page? And of course keeping the selection that drove us to the first drill-through page?That would be super useful. Thanks in advance and keep up the grrrrreat work...

[@ericjoyner9072]

GREAT video. So I have a curveball for you and hope you have some advice. I have a Slicer visual with a list of "VPs". In your example, it would be a list of Manufacturers. For whatever reason, the button does not "Drill Through" when using a slicer visual. My use case is, I dropdown the slicer and select the VP I want to view details or and then click the Button to drill through to the VP details. This button works perfectly if I use a Table visual, but when I use a Slicer dropdown visual, the button will not drill through. Any suggestions?

[@Astrid-um9lz]

I am looking for a solution for the exact same problem, did you ever find out how to do it?

[@BilalMakki-kf4dy]

HI, in my case i used measure and link in condtional formatting etc , when i try to navigate it's show that " Unbale to drill through or page not availble"" but page is also available and in slicers also made pages etc

[@HowtoPowerBI]

maybe typo in page name .. extra space at the end ?

[@BilalMakki-kf4dy]

@@HowtoPowerBI Wooooooooooow , u r Genius😍

[@Eaglegamer999]

Sir please help me. I have drag two values in bar X-Axis. Item in Y-Axis. Now we can see two different values in single bar. I want to drill through based on single value in bar. Usually we can drill through entire single bar but i want to see based on value selection in bar. How can i do it.

[@yokimatzu6829]

pie and donut chart in main report and respective table for each chart on drill through page(single page) when i drill through from pie chart it needs to only show pie chart table and vice versa.is this possible

[@DavidShaw-dc4re]

My power bi desktop UI does not look like yours and I couldn't get the button to work

[@ArpitSharma-kk9tl]

How to do drillthrough from one report to another

[@Bharath_PBI]

Try cross report drill through.

[@HowtoPowerBI]

1) Go to options / report settings, allow visuals in this report to use drill through targets from other reports. 2) Under Drill through, set the Cross-report toggle to On. 3) The fields you want to pass must exist in both data models (same table name and field name, case sensitive).

[@sravankumar1767]

New concept but little tricky to understand

[@HowtoPowerBI]

Bit tricky, but I hope the video helps implementing it 🙂

[@ianstats97]

Its pretty good, but is time for a one click option to be designed by microsoft

[@HowtoPowerBI]

how would a one click option look like?

[@abiel237]

This guy i c BI devlopper . He can code a game with DAX 🤣🤣🤣

[@lukeminikoski]

This is known as plagiarism! LOL

[@HowtoPowerBI]

? Dont get it, why?