 Hey guys welcome to SSUnitech, so we will decide and this is continuation of Power BI Tutorials. So today we are going to discuss about the hierarchies and drill downs in the Power BI. So these are very important topics in the Power BI because by using these two options we can create the dashboard that will be more interactive and we can also see the detail level information in the same page. So what it means and how we can do this lets jump to our project and we will see in practical. So go to the Power BI desktop and here I have already created so first let me explain what I want to create after that we will see how we can do this. So here basically we are having this column chart and in this column chart you can see in the bottom we are having the country names and in the y-axis we are having order quantities. So basically what we just want to click on the United States so it will jump to the next level and see the same information as per the cities which belongs to the United States. So click on that and here you can see all these cities and these are going to belong with the United States. So basically this is the first level drill down. In the second level drill down we can also click on any one of these cities so it will jump to the next page and here you can see it is having postal code and you can see the information for that particular postal code and if we want to go back then you can see in the right top we are having this drill up arrow we can click on that it will jump to one by one in the base phase. So basically this is our requirement by which we want to create this drill down and next is the hierarchy so basically hierarchy like first level is our country second is city next is postal code so our hierarchy will be the country city and postal code. So let me create a new page so we can click on this plus icon so it will create a new page. And here first of all let me use a column chart so we can click on the column chart and now make it bigger and here as I told you in the x axis we should have the country city and postal code in a hierarchy. So how we can create the hierarchies right here so here you can see in the left side we are having the city and country so we can press the left mouse button and drag the city on the country so it will create the hierarchy with the city and country you can see right bottom right here this we have already created so if you want then we can delete otherwise leave it so this is which we have created for city and country next level that will be the postal code so here you can see the bottom that will have the postal code so we can drag this postal code and drop on that hierarchy so it will create a new hierarchy that will contain country city and postal code. So now in the axis we just want to use this hierarchy instead of the city or country or postal code so we can drag and drop this in the axis. So here we are having country names because this is our first layer now in the values we want to have this order quantity so we can drag and drop the order quantity in the values here we want to summarize so it is already summarized that looks good so here we can see we are having this United States, Canada, UK, France, Australia and Germany so now if we want to click on this then it will not going to jump to the next phase why it is not going to jump because in the right top you can see few arrow so these arrows will help us to drill down in the second of arrow that is click turn on drill down so once we will enable this after that it has the ability to drill down now we can click on this so here we need to press the control and click so it will jump to the next phase and if we will press the control on this so it will jump to the postal code. Now you can use this top arrow so it will drill to our first phase in the right side as you can see this is go to the next level in hierarchy so once we click on that it will jump to the next if we click then that will jump to the next because here we haven't select any country any city that's why it is showing all the data for postal code. Now in the right side you can see the last option that is expand all down one level in the hierarchy so what it mean so let me click on that so once we will click on this then it will expand the data but here in the x-axis you can see the country and city now let me click one more time so this time this will have the country city and postal code so you can see all the data on the x-axis so this will help like that so that's it for this video see you in the next video if you like this video do subscribe our channel and press the bell icon so you can get the newly uploaded videos first thank you so much guys