 Hey guys, welcome to SSunitech, so see you on this side and this is continuation of Power BI tutorial So today we are going to discuss about the filtered types in the Power BI So in the last video we have seen about the types of filters that can be applied in the Power BI desktop reports. So today we are going to see about the filtered types So basically again we have three type of filters first can be basic filtering Second will be advanced filtering. Next will be top-end filtering So we will see one by one in the practical. So go to on Power BI desktop and see in the practical So this is our project by which currently we are working on. So first of all, let me use the column chart and try to make it bigger and And here as you can see we are having this data set So this is our country name. So let me drag and drop the country name in the axis and in the values, let me try to drag and drop the order quantity and Here you can see the countries in the x-axis and the values in the y-axis That looks good. Now go to on the filters. So you can see right here. So click on that If you will not see this filters option right here. So don't worry go to on the view and Here you can see this filter like it is selected If you will unselect this then that will not be available right here If you will select then you can see the filters Now here you can see the filters on this visual First we can see the country names and second in the order quantity Because we have used these two fields in our visualization now go to on the country name And here you can see the basic filtering that is the filter type one So in the basic filtering you can select one by one like Australia, Canada, France, Germany UK and US As you want So you can select one by one right here. That is our basic filtering now go to on the Advanced filtering so in the advanced filtering here you can specify the and and or condition so what it means so here you can see the First option that is contains doesn't contains starts with doesn't start with is Is not is blank is not blank. So these are the options available. So I am very happy to use It starts with so it should be start with united so you can call this as United And here you can see apply. So once we click on apply filter, then it has only two Countries because it is starting with the united. So this is our first condition And in the second condition either you can use and Or you can use all so I am going to use and after that we will see the all now here again. It should be It starts with We have already used so here we can see doesn't contain So what doesn't contain states? So We can see states now we can click on apply filter So now this time it is having only united kingdom Because it should be started with united and doesn't contain the states So here you can see like that If we will use or condition and click on apply filter So this time we'll see all these conditions because it is saying either it should be started from united or it should Not contain the states. So that's why we are seeing all these values So I hope you understand about the advance filtering and how we can use it Now go to on the top end. So go to on top end and here you can see the So items so top and bottom these two options are available Here you can see specify the numbers like we want top three top five like that So I am going to use top three And it is asking from which value you are going to calculate the top So I am going to calculate the top by using order quantity So we can drag and drop the order quantity right here And here you can also Use the sum average min max count count distinct as you want. So I am going to use the sum After that we can click on apply filter So it is having top three like united states, then canada, then united kingdom If we will change this as bottom and click on apply filter, then it has France Then australia, then germany So this is bottom three. So we can use top and as per our requirement So in this video as we have already seen like Filter types first is basic filtering second is advanced filtering and next is top end filtering So guys I hope you have understand how we can use this So thank you so much for watching this video 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 one