 What's going on everybody? Welcome back to the Power BI Tutorials series. Today we're going to be looking at how to drill down in visualizations. So when I say drill down I mean you're basically adding another layer beneath the top layer of the visualization and when somebody clicks or drills down into that data they can see more insights and more information on the top level of data. When you drill down you can also drill up and I will show you how to do that in this tutorial. So without further ado let's jump on my screen and get started with the tutorial. All right so before we get started I wanted to remind you that you can find the data that we are going to be working with in this tutorial in the description you can go and download it from my github. Now the two tables I'm going to be looking at are Apocalypse Sales and Purchase Tracker and if you've ever created any visualizations you've probably seen something like this where you'll have the store and the price and this is the the things that we actually bought. So this is the total amount of apocalypse prepping equipment that we bought and we'll put the store in this legend right here and you've probably seen something like this and if you're anything like me you're going to be in a meeting and you're going to be presenting this and some higher up is going to be like hey Alex Alex great but I want to you know see what things we actually bought and targeted how much this cost can you create a visualization for that and you're going to be like well I could or I could use drill down and so you could have done this in the first place which you should have. So what we're going to do is all we're going to do is we're going to say we're going to say the product right here and these are going to be the actual things and we're going to put it right under store. Now you can't see these things right but there is a a hierarchy here so once we added this these options became available let's take it out and all those just disappeared and then we add it back right here they came back and so you can do right here which is click to turn on drill down you can go to the next level in the hierarchy or you can even expand all down one level in the hierarchy so let's look at each of those really quickly so let's click on this one it's just going to turn on drill down mode so now if I go and I click on target it's going to drill down into these and if we want to I can then put product under this legend and we can see all of those things but of course if we go back up it's going to be all broken up into this cluster column chart which is more like this which isn't exactly what we were going for but it works now let me get rid of this actually one store in the legend now if we turn that off and we click it doesn't do that anymore so what it does now is it just highlights Walmart it highlights Costco it highlights target so we're going to keep that on but we can also do something called going down the next level of hierarchy so let's click on that and so now this is going to go down to the next level down to this product level because that is the next level and now it's going to show us each of those things but it's going to have it broken out by the store and so it's a completely different visualization but all within the same realm of the data that we're looking at and what we actually care about so let's go back up in the hierarchy and then let's use this one right here which is expand all down one level in the hierarchy and so this one is again extremely similar except it just visualizes it differently and now what it's doing is Walmart rice target dried beans Costco rice so instead of having it all like this one where it's stacked on top of each other it's breaking it down individually so this one column would become three separate columns now I'm going to minimize this right here I'm actually going to go back up in the hierarchy just for visual purposes now I'm going to show you one more example and we're going to use this apocalypse sales up here and this is one that I actually use all the time so the one you've seen it you know you'll get stuff like that especially if you're working with like sales and stuff but I work in operations right so I have a lot of order IDs product IDs stuff like that now this one this one genuinely I use quite often I'll have a customer let's make it we'll just go like this we have a customer and we have units sold and let's use the customer as the legend so let's make this one quite a bit larger and I'll have something like this and they'll say okay well we want to see the order IDs that go with it because we want to know what orders are actually happening for each of these people obviously I'm not using this exact data but very very very similar now all you have to do is take these order IDs and slide it right here under customer and this visualization right here is something I've done a thousand times because what happens is is someone some stakeholder in our company is saying hey Alex we want this and we want to know we want to drill down on this IP address we want to drill down on this certain database we want to drill down on something and we want to see the order IDs within them so then all you do is you turn on drill mode or drill down mode you'll click on it and you can see every single order ID that's in there and then they can go and look those up in their system and resolve them or whatever they're trying to do with it and it helps a ton and it's very very useful this one is extremely applicable and that's really all drill down is again you have these different hierarchies as well but for different things it's not as useful as you can see you also have this hierarchy which again is not as useful so it just depends on the data that you're using and how you want to use this drill down effect but I promise you that drill down is used all the time especially when you're giving presentations where people want to know more information than just the the visualization that you're presenting so I hope that this has been helpful I hope that you understand drill down a little bit better if you like this video be sure to like and subscribe and check out all my other videos on Power BI thank you and I'll see you in the next video