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

In this video I show you how to set up a drill through action on a button. Enjoy the video and subscribe for more videos like this!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
1:09 Setting up drill through
3:23 Using buttons to perform a drill through
4:36 Conditional button text
7:55 Conditional tooltip text
9:37 Conditional drill through destinations
13:25 Customizing the drill through
14:54 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZbin: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

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

[@user-kw7ce2mh3j]

This tutorial is absolutely amazing. Very helpful

[@tauraik]

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

[@MrAszpic]

100% complete, thanks a lot for sharing!

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

[@sivamagesh]

Your videos are very clear and helpful

[@ahmadbakr3738]

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 :)

[@jhewitthunt]

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

[@satyakanungo4176]

Thank you my Teacher

[@sethpark2539]

You have so many creative ideas! Thanks for sharing.

[@HowtoPowerBI]

Thank you Seth! 😊

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

[@totvabe1]

Very useful, Bas!

[@bravucod]

Great tutorial!

[@HowtoPowerBI]

thx Daniel!!!! 😀

[@youjohnny16]

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

[@lemianelson2012]

This is amazing 👏🏾

[@HowtoPowerBI]

thx Nelson!!! 😃

[@williamviegas]

Thanks for sharing!

[@HowtoPowerBI]

thanks for watching William 😊

[@TrassBI]

Very helpful knowledge. Thanks for sharing!👍

[@HowtoPowerBI]

Glad it was helpful Trass! thx for watching! 😀

[@tubeitz]

So good, thank you

[@HowtoPowerBI]

Thanks Varun!

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

[@gaborbereczki6484]

Super useful, thanks for sharing!

[@HowtoPowerBI]

Glad it was helpful! thx Gabor! 😀

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

[@rameshkandi]

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

[@HowtoPowerBI]

Awesome! thanks for watching Ramesh!

[@MaurizioFaini]

Ehi, great video! Thanks so much Bas!

[@HowtoPowerBI]

thx for watching Maurizio!

[@chengwang411]

The most good looking PBI instructor 🤣

[@ymohamed3154]

Amazing👌👏👏

[@HowtoPowerBI]

Thanks 🙏

[@Vicky_s16]

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

[@shruthil7913]

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

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

[@johanynavarro8065]

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

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

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

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

[@Bharath_PBI]

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

[@joelgonzales720]

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

[@100SAYWATNOW]

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

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

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

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

[@Theozzie11]

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

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

[@MSBI_expert_]

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.

[@sravankumar1767]

New concept but little tricky to understand

[@HowtoPowerBI]

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

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

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

[@lukeminikoski]

This is known as plagiarism! LOL

[@HowtoPowerBI]

? Dont get it, why?