 Hey guys, welcome to SSUnitec social decide and this is continuation of Power BI tutorial. So today we are going to discuss about the treemap chart in the Power BI. So this is very important while we are going to design any dashboard. So if we use the treemap chart then your dashboard will be more interactive and more beautiful. So go to all the Power BI desktop and we'll see in the practical how we can do that. So this is our project on which we are currently working on. So inside the visualization you can see we should have a chart that is treemap. So we can click on that and now let me try to make it bigger. Now we can see here group, detailed and values. After that the tooltips. So we have already discussed about the tooltips. So if you haven't watched that video go and watch. Here let me try to drag and drop the country in the group. After that let me try to drag and drop the order quantity in the values. So here you can see the more value which is available in the United States after that the Canada then all these values and it is displaying like that. But here we don't have the values that is displaying. So how we can do that? Go to the formatting and here you can see the data labels. So we can on that. So here we can see it is having the values in the thousands but we want the exact numbers. So again in the data labels you can see the display unit we can set it as none. So it will have the exact numbers that we are looking for. So this is the first option. Next we can see the data color. If we want to make the change on these data colors then we can see we can make one by one from here or here you can see the advanced controls. So we can click on that and here you can see it is having the minimum value and highest value. So by using that it will be arranged or here we can see format by we can set the rules or we can see the field values. So we have already discussed about that part. So I am not going to explain that in this video. So this is the tree map chart our requirement is we want to see only top three countries. So how we can do that? For that we need to go to on filter then here you can see the country names. So we can expand that and here in the filter types you can see three type of filters. First is basic filtering we can select one by one then advanced filtering. So in the advanced filtering we can set contains or end and condition can be applied. But here I am going to use the top end and here we can set as three and by which value we want to get this top three. So that is from order quantity. So we can drag and drop the order quantity in the by value and here it should be some so it is some that is good. Now we can click on apply filter. So now it will have only top three countries and here we can make the change on the title so go to on the title and instead of this text we can see top three countries data. So you can see it is changed. Now what is our next plan next we want to make it more detailed information like if we click on this country then we want to see the data for the city level. So for that we don't need to worry about that go to on the fields and here just remove this and in our earlier videos we have already created the hierarchy. So let me go and drag and drop the country hierarchy from here. So now you can see it is having country name city and postal code. So I am not going to go in depth to postal code so we can click and remove that. So now it has only country and city. Now let me try to click on this and let's see. So it is not working because we haven't enabled the drill down option. So we can click on that and try one more time. So here we can see all these cities data is available but this is very fuzzy so go back and let me try to apply the filter for United Kingdom that is much more better and very good display. So while you are going to use this so it will be very helpful and very beautiful for your visualization but you have to remember you should not have as much depth information like we have seen for the United States otherwise your chart will not be as much beautiful as you are thinking. If you like this video please subscribe our channel to get many more videos don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much see you in the next video.