 Hey guys welcome to SSINI Tech Succeed Decide and this is continuation of Power BI Tutorial. So today we are going to discuss about the slicers. So what is the slicer? So this is a very important topic in the Power BI because by using these we can filter the data for the visualizations. So go to on the Power BI desktop and we will see in the practical. So this is our project by which we are currently working on. Let me add a new page. So we can click on this plus symbol and here let me add few visualizations. So first I am going to use the column chart. So this is our column chart. Let me make it bigger and next I want to use a line chart so we can click on that. First unselect that and now let me click on column chart here put it on right side. Next I want to use a table so we can use this table make it on right side. Now we can little bit adjust all these. So little bit smaller I guess now it looks fine or we can set it on the top side like this and like that and we can make it bigger like that and this as well so we can set and make it bigger. So here I am going to use these three visualizations. First is the table, second is the column chart and a line chart. Let me add the fields on this. So first I am going to use the country name, second city name. Next I am going to use the order date so we can drag and drop. So here you can see it is having the data in the hierarchy but I am going to use exact value so we can click on that and here we can select the order date so it will have date value. Now next I am going to use the order quantity so we can drag and drop and let us make it some so it is already some. Now we can make it smaller like that. Next we can select this line chart and let me drag this country name on axis and order quantity on the value. Next select that column chart and country name in the axis and order quantity in the value. Now I am going to use a slicer so here you can see inside the visualizations this slicer is available so we can click on that. So this is our slicer so first I want to apply the filter for the country so we can drag and drop the country name on the field for the slicer. Here you can see it is displaying data like that so these countries are available so we are having all these countries. Here in the right top you can see this down arrow so we can click on that as of now its displaying as list we can make it as drop down so we can click on that and here it is converted in the drop down. If we want to format this then we can go on the format and here you can see slicer header if we do not want to see this so we can off this and here in the title we can add that so this is the country so we can call this as country and here little bit down this is our font color and this is our background color so let me change my background color with orange after that the font color that should be white so this is white so that looks good so we can do the formatting as you want. So this is our first slicer and here let me filter for US only so we can select United States so here you can see data is filtered for United States and here we do not have option to select all so we want to see that option as well so again select that slicer go to on the format and here go to on the top here you can see the selection control so in the selection control you can see select all so we can on that now you will be able to see select all options so we can click and we will see all these values and next I wanna filter only data for these two visualizations not for the tables like if we will select here for United States then the data on the visualizations will be changed not in the table so how we can do that that is also very important so I have already discussed about the interactions so we can select that slicer go to on the format and here you can see edit interactions so here this is our table so in the table we do not wanna put the filter for this so select the slicer and here in the top side you can see option for none so we can click on none so it will not be filtered anymore now you can check as we have selected United States so here we are having data for all countries only these two bottom visualizations are filtering next I wanna add one more slicer so we can click on that and this is added this time I wanna use for date slicer so here you can see the order quantity let me add this in the field so this is our date slicer so here it is gonna use the between like it will forget the data between these two dates but if we want only the data after any date or before any date then we are also having that option here you can see on the right top click on that here you can see the before after list drop down relative date relative time so here let me add between as it already so here if will use the before then will have only after date and if will have after then will have only start date and list so it will display the data in the list and if will select the drop down then will have this drop down so we are having all these options we can choose according to our requirement so this is our slider so we can slide this and the data for the slicer will be changed according to this slider so this is for the slicer so guys 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 off newly uploaded videos thank you so much see you in the next video