now there are going to be situations where you have a visual that you want to allow your users
to drill into and get a little bit further insights based on what they're selecting
and in this video i'm going to show you how to use this drill through feature to get that done
let's say our goal here is we want to allow the user to drill in from this customer and go to
another page where there's more details and and have it just for that customer we would go from
aaron campbell and if we selected that person let's say it took us to this page sales by
year and we would want this to be just for that individual selected in our case again in our case
it's an individual but it could be for anything my first thought is to do something here on this page
but it's actually not where you make this change is on the visual where you want them to drill into
so in this case we're looking to go into here and this is where we'll actually set that attribute
we'll select this component here now this drill through area here is how we'll get this done we
said we want to be able to select a customer name to drill in so what we do is go to customer name
drag it onto this filter now what will happen is any other component that has a customer name
can drill into this page here we're allowing it to happen if we go back to this other visual
right click now we see this option for drill through and it's giving us the name of that page
where that visual has that we said you know what you know if you have this customer name
field you're allowed to drill through into here and we'll filter it based on that field
so let's select this now it's taken us here and filtered this for us because we set that
filter i'll also point out that because we're saying keep all filters it's keeping everything
as it is so we have category name here and it's keeping those the same here you'll see that down
here so now that worked and you know if we were to go back and you know if we select this one drill
through now we have this filtered by that person and what you'll notice here is this little guy
up here when whenever you add something to this drill through it's automatically going to add
this button here and all this is is a back button it's going to allow you to go back to the page
where you came from because we're in editing mode here i'll control click and it'll send
me back here and that's the workflow they're trying to set up so drill through see it go back
drill through control click go back if we look at this visual here there is no customer name
so when we right click we don't see that drill through option it's not allowing us but let's
say we want that as well we'll come back into this into this guy again and it's this time we'll add
color to one of the available drill through fields now if we go back here right click drill through
sales by year is now an option just like this and all of this is going to be filtered by that color
so as i mentioned initially all this is right here is a back button so let's say you wanted
to customize this and use a custom image what you can do is insert an image i have a custom button
here that i found and in the format we can set the action to back and it'll function the same way so
now if we were to control click here start doing some of these same motions it'll work the same way
and we can get rid of this guy let's say this is what we wanted and there we go
so that'll do it for this video pretty straightforward on how you can use drill
throughs in power bi to enhance the way your users can interact with your dashboard
and add some more advanced functionality to your reports if you found this helpful
please feel free to like the video or leave a comment and i'll do my best to
answer your questions if you want to see more content like this if this is interesting to you
feel free to subscribe but as always thanks again for watching and i will see you at the next video