Power BI - Drillthrough on All Columns and Measures with a Single Field

In this Power BI tutorial, you will learn how to set up drillthrough in a dynamic way! Even if your end-users alter visualizations on the Power BI Service using the new Personalized Visuals feature, your drillthrough will never break. It's actually really easy to set up as well!
Live, Real-World Datasets:
training.bielite.com/datasets/
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite

[@Qweertyyuiiop]

If anyone is having problems with "Cant display visual relationships between fields error", make sure you are using MEASURES as values. Otherwise you will get errors! Learn your measures people! Awesome video!

[@Qweertyyuiiop]

Also if anyone knows how to use this with charts that already have a field in Legend?

[@andreamangano338]

That's right...it only works with measures

[@mauryavijai]

I have a similar use case and found this trick very helpful.

[@allthingspowerbiwithadebol3576]

So good! Thanks a lot for sharing this.

[@feng3625]

This is really Miracle ! what a wonderful design!

[@nirholtzshtein2686]

What a great workaround!

[@ChrisSmithFW]

This is great! Love it. Much appreciated.

[@Symium]

Great video, how do you do that personalize settings @ 1:20? thanks

[@kennethstephani692]

How about drilling through from a value in a matrix?

[@twkyoscr]

Is there a second video that explains how the button is activated and how to set that up? Also how are you filtering the detail from the chart?

[@abhijeetghosh27]

This is amazing @Parker. Thanks for sharing 😀👍

[@user-kz5vl5eo4h]

Great video. Will this work if you are drilling from a Matrix Visual? If so, where do you put the Drill through DO NOT Remove field?

[@vimalmanavalan]

is there any way to drill through to details page from a table chart??

[@Sandroider]

What if I have table with status fields (with conditional formatting), how to get it to work. So if there is yellow or red symbold I can click it and see descrption field of that record? there is no drill option when right clicking the table?

[@datawhipper]

Hi, tried to do this now, but whenever I add the "do not remove column" to the legend or details field, it goes blank. Is it still working?? 🤔

[@mcnater]

That's good stuff! Thanks for the tip.

[@BIElite]

Thanks Nate!

[@jyotidatta2126]

Informative. But not working for me. When I try to apply this setting in Gantt chart, it gives an error saying the relationship could not be established with the new drill table. Is there any way I can make this work?

[@leonardomauro7894]

Amazing, just amazing. Keep going, you are amazing!

[@BIElite]

Thanks Leonardo! I appreciate the kind words.

[@leonardomauro7894]

@@BIElite I thank you.

[@samasfilmyfreak]

Can we also drill through on that quantity card ?

[@Im_Thanos]

Thank you for this.. But it is not working in the recent one's.. When used in a bar chart it says 'There is a missing relationship between these fields'. Is there any workaround for this, Sir?

[@ChrisSmithFW]

You don't need a workaround. You need to connect the tables.

[@gznqtl]

Great!, I just looking for this trick.

[@BIElite]

Glad to hear!

[@rampathakur9281]

it is showing additional bar when I add in bar visual

[@vishalpawashe9487]

Brilliant !!!!

[@alexbehrmann9557]

I have different detail tabs, how would i modify this to drill through to the right tab?

[@BIElite]

Power BI just came out with dynamic page navigation and drillthrough. Give it a try!

[@skillguru286]

How will it work without having relationship with other table? When i am trying it is showing error

[@akhan8076]

Hi, Has anyone got the answer for this question as i am getting the same error? Thanks

[@sadyaz64]

Excellent

[@BIElite]

Thanks sadyaz!

[@shoeb1359]

Amazing !!! it's not working with slicer selection, When i putting drill through columns in Field visual giving an error. Is there any work around?

[@BIElite]

Hi Mohammad, sorry I don't follow. Are you trying to put the Drill column into a slicer visual?

[@shoeb1359]

@@BIElite Yes, slicer visual have different-2 status so i want if anyone select any status in filter then drill through button enabled and can be redirect to detail level page keeping filter of selected status

[@shoeb1359]

Please reply . is there any work around?

[@BIElite]

Ah yes, this is easy with the sync slicers option. It isn’t the same as the drillthrough we set up in this video, but if you sync the slicers across both pages, you will be good to go!

[@ravitejak9414]

show me how to put drill through on the custom visuals

[@walidkhlil2872]

thanks

[@BIElite]

No problem walid!

[@alexrosen8762]

Wow!

[@frankgovers8420]

Great

[@BIElite]

Thanks Frank!

[@yulirashti6141]

It is not working with Stacked Column Chart. If I add to legend, I get error: "There is a missing relationship between these fields"

[@BIElite]

That's very interesting... I didn't have any relationships set up in my model. Which version of Power BI are you using?

[@yulirashti6141]

@@BIElite I use version 2.8.5831.1181. In some charts it worked great and in others I got an error

[@tuyoexcelypowerbi]

@@BIElite Same for me, it does not work for any chart. Versión: 2.85.985.0 64-bit (Sep-2020)

[@amitnarayan09]

@@BIElite please help if visuals have relationships in such case how to apply this

[@SergiyVakshul]

"but that's a little bit redundant". If all I need to do is to put three measures in a single drill-through well then what could be redundant doing so three times? What you do is place the dummy field three times into three different visuals, plus create a table that is redundant indeed, plus the dummy field now appears in a tool tip

[@BIElite]

And if you add a new measure to your report you will need to remember to add it to the drillthrough. With this method, you won't ever have to do that and the drillthrough will work with the new measure. Thanks for the comment though.

[@olabakheet9621]

why not working with me

[@jesuseduardobittersuarez7517]

powerbi already MOVE ALL AND HIDE all the bottoms , dont know

[@dibassimohamed5514]

Nice but not workimg