Power BI - Slicer

Hello friends and welcome to Tutorials Point

In this segment of the video I'm going to show you how Slicer work in Power BI Desktop

So guys, Slicer is being considered the one of the most powerful type of visualization

especially when you'd like to make your report a little dynamic. Now you must be wondering what is the Slicer

A Slicer is basically an on-canvas filter in PowerBi Desktop in such a way that it lets me look into a report segment

by a particular value. For an example I would like to view the visuals

according to different ears or I would like to see the visual according to region wise. All right guys. So how to

add this slicer is very simple. You simply have to go under the visualization

pane and you have to select the slicer visualization. Once you have selected the slicer visualization we have to go under the

field pane and you have to choose a field which you want to slice it

and you simply have to pick that field and draw it onto the slice place holder where you see the slicer

Alright guys, once you have dropped that slicer, you can see that the slicer that you can see on the report page automatically converts into list of elements with the check box

So you simply have to click on the checkbox to see your visualization

So how this slicer works and how to apply the slicer will go ahead and see in our practical approach

Hello friends and welcome. In this video we are going to see how to use slicer in Power BI

So let get started off Under the visualization pane we have something called as slicer So I simply select this slicer The moment I select slicer I can see an empty box out here in which I have to introduce the category So what we will be doing out here under the product table I have something called as category The moment I select this category and drop it under slicer you can see the unique values of all the category out here that is mix rural urban and youth We basically have four category out here So that the reason it is show

me all the unique values alright now I will quickly go ahead and increase the

size of it and see what happens under the format section I will go under the

items and I'll increase the text size so that it is visible to everyone all

right okay that sounds good that looks good now I can see the names out here

okay I'll simply go on the slicer now now what does a slicer is nothing but a

user interactive filter that means whenever I want to see a projection

for a certain category that means I want to see the projection for the rural category

so it is showing me the projection only for the rural categories now as you have

seen all these reports are interconnected the moment I select a slicer and a

select mixed category all my projection that is my tree map and my pie the

donut chart and the film map changes accordingly all right for youth it is

changing its color it is changing its revenue as well so it is a

basically a filtered out projection with the help of which with the help of a single click I can get my desired projection all right guys so this was something simple now let say that if I want to have multiple categories that means I want to see the result for rural and urban so I simply have to select the control button and then hit On urban so I getting the projection just for rural and urban itself

Alright guys so it's was very easy to use a slicer now we will go ahead and see what are the different type of slices that we have if I click on this drop down

It is firstly showing you as a list. It is also showing you as a drop-down. What do you mean by drop-down if I select this drop-down

You can see there is a drop-down for all. If I click on this drop-down, it is showing me list of all the responses

So, it's completely up to you which slicer that you have to use, whether you want to use a drop-down menu

or whether you directly want to select it, use it as a list

Now, we will definitely use a drop-down menu when we have long range of list, right

The categories, as of now, it's four. That's the reason I can see it in a list

But let's take for an example. I have 20 examples out here or 20 categories out here

So it will acquire more and more space and apparently making populated, making much more space for the slicer portion

Right. So this is what it is used for drop down and list

All right. So this was some basic thing. Moving on to the next thing that I will go under the format tab

And under the format tab, what we can do is basically I can change the layout, the colors, the way it is looking right

now but we will not focus on that this can be done by according to your own need the way

you wanted and the way you like to have the background color for all right as of now everything

is off because it just a simple plain slicer i would like to see it as simple as i can all right now the one thing which I want to show is the selection control if I click on this drop menu there the two options firstly it says show select all option so if I turn this

thing on see what happens to the slicer I will get an option of select all so I

can simply select all or I can select individually completely up to you so this

is what the select button is doing let's turn this thing off and let's try the second

one that is it says it is saying single select that means if I turn this thing off

see what happens if I turn this thing off it is giving me an option for checkbox

that means I can simply select one or one after the other without using the

control button as of now I'm not using the control button I'm just selecting it

one by one so that my filters or my slicer is giving me the results accordingly

upon the selection of category that I have all right guys so this is how it is

working now if I click on this drop-down menu there is an clear selection which

means if I want to remove this slicer if I can simply select this slicer

select on this so all the filters will be automatically removed so now we have

already seen that in slicer I can either get a list or a drop-down or if I want

to select multiple whether I want to keep it selected I simply have to go under this

format tab and under the selection control I can select the the required whether you want to select all option whether you just want a single select

right so depending on that i can modify my slicer according to my own need all right guys

so this was all about slicer how to use them how to modify them and how it works in power

b i hopefully you guys like this video see you and till next time