Original subtitles

Welcome to this lesson.

In this lesson, we're going to start looking at some further filtering capabilities that we have within

Power BI.

So previously in the lessons I've mentioned, the Power BI is really powerful when it comes to filtering

data.

So in this lesson we're going to be looking at the slicer.

So the slice is really great when you want to be able to create a user interaction where the user selects

something and then the data that's on the page gets filtered by the selection.

So we've come back to page one, and what we've got is we've got these cloud visualizations we created

earlier and we've also got a multi row visualization with some data back.

And so we're going to be using the slicer now to actually filter this data again.

So let's start off, if you go across your visualizations, you'll see that the visualization for the

slices, the one that looks like it's got the funnel just like that and it will create a placeholder

like it has previously.

The next part that we're going to do is we're going to populate this and we're going to use our product

category.

So I'm going to see how our product category HD now filters this data, right?

So let's try it with our audio so you can see straight away, as soon as I pick audio, then the visualizations

now get filtered and only the audio titles are shown.

You can also see that you've got cameras and camcorders, you've got cell phones.

So as you select these, it's now just filtering those visualizations.

Now, if we add other visualizations on here, tables or matrices or graphs, it would just do the same

thing.

It would automatically filter those.

You will see there is an option to be able to hear the selections as well.

You can have a look at the formatting as well, so you can change the formatting of this.

If we go in the format, you'll see that we got our general ones, you've got your properties, your

title that we've seen or fixed as well.

So let's move across to our visual.

So you see that we've got a slicer settings, so you get different styles.

So the vertical list, you have a tile or a dropdown.

So let's have a look at the dropdown first.

So the dropdown just creates a situation where you don't want to use so much screen real estate and

then basically you would then click on this and then make your selection from here and then again click

off it.

You will see that the dropdown now takes a lot less space.

So that's one option that you could use.

You also do get another option.

Just select that.

Go back to slicer settings is the tile option.

So you'll see that this now creates a view where you get now your options as taught.

And again, if you select on this, you can see it's just selecting them and it's doing the same job.

So I'm actually going to stick with the vertical list.

Probably just easier to see and to view.

So you can change how your selection happens.

So do you want a single select?

So if you say on so in this case now you're going to only pick one item at a time.

Tensions the selection to be also that you could use the multi select with the control key so you could

select that or you could show the select all button.

So if you add the select all button just means that all the items will be selected or there we go,

It's also all the items there.

So just to add that in there.

You also get the ability to format your slice a header.

So what is your text and your friendship?

What are your background?

Also, how do you want the values to be displayed?

So you do get quite a bit of control in terms of the way that those are displayed.

But again, I'm going to leave you to experiment with the different formatting.

The key parts I wanted to show you is really the options and the selections.

Now, when it comes to our text slicer, there is one more option that I want to show you, and that

is the ability to actually be able to create a hierarchy.

So what you can do is you can put fields underneath fields.

So if we have a product category, we can also then have product subcategories.

So if you drop that underneath, you now see that a hierarchy gets created.

So if I click on the hierarchy, it will now show me options for the product subcategory underneath

the product category.

So I could say now I want to see the Bluetooth headphones or the MP four and the MP three, and I'm

now actually using the product subcategory to be able to filter.

Again, I forgot on the cell phones, you'll see now that the product subcategories associated with

that product category are now shown.

So that's quite a nice feature if you want to use hierarchies.

Again, if you want to remove that, I will just simplify your actual slicer.

Now we do get different types of slices as well.

So basically here we've been working with text, we've been working with the product category.

What you can do as well is you could create a numeric slicer.

So let's just clear that.

Let's add a new slicer and let's say, for example, we want it to be able to see what was our totals

when the price was between, say, $25 and $50.

So what I'm going to do is I'm going to actually use the price field as a slicer.

Now, what you'll see is automatically is that this is now being added in using a slider.

So I could actually use the slider and I could actually change the price figures and I could drag that

or I can just enter it here.

So let's say I wanted to say the price is $25 up to say $50.

Press enter on that.

And again now it will go through and shows me now all my sales totals, profit total average sales values

for when the price was between those values.

Again, you're able to come in here, you can actually clear these and clear the options.

And again, you could look at your formatting and you could see what is your slicer settings.

So if we look at the slicer settings at the moment, you have a star, which is between so it's between

this value and this value.

But you could say, I want to see when my value is less than something or greater than something.

So let's say if the value is less than so in this case.

Now let's say I want to see what happens to my totals.

If the value was my price was less than $100.

Press enter on that and you can see I can't change this one because it's now less than.

Could also change this and say, I want to see when it's greater than or equal to.

So you could say, I want to see where the price was greater than $50.

So then we'll take from $50 now to the end point.

So you just come into your options, change your style, and you're then able to change how that is

within numeric figures.

You can also have a vertical list if you wanted to, but you'll see it just lists all your prices up,

which in this case would have makes sense.

Could tell those as well.

Or you can have a dropdown.

So it's got the same options that we saw over here.

But in this case, Queen would probably make most sense for what we would be using this for.

The next topic.

Slider I want to show you is when we're working with Odd Date.

So again, let's just create a new slicer, so we're going to add a new placeholder.

And in this case, now we're going to add our order date into the slicer.

So let's drop that in there.

So now we've got a date and automatically you can see that it's again created a slider just like it

did with my numeric value.

But in this case, it's now got dates.

And the nice thing here is you do get a calendar dropdown, so you could decide that you want to change

the different years and values.

If you want to say 2013, January the first, for example, and let's say we want to take this to 31st

of December 2013.

So again, we can just go back up there.

Let's go back.

December 20th 1330 first.

So you can just pick the range of dates again.

You could use a slider if you wanted to, so you could have the dates then given by the slider.

So that would be your between option and using the slider.

And again, you can just see that it's filtering the data as we go.

Again, if we go now into the formatting for this, you'll see with the slicer settings.

Now in this case you can see that the style has been set as between, but again, we could say before

specific date and you'll see that only this date is now open for selection.

Or you could say, I want to see after a specific date and you'll see then only this date is available

for selection.

So anything after that date will then be displayed.

So as you can see, that works pretty much exactly the same way as a numeric slicer does.

However, the order date does have an ability to do something different, and that is to create what

is called a relative date.

So let's have a quick look at that.

So if we go to a start, you'll see that as we go down, you can have a relative date or a relative

time.

And we're only dealing with dates or not with times.

So I'm going to select relative date.

What this allows me to do is to pick the loss the next or this.

So in this case, let's say I want to see what happened in the last six months.

Now, my data is quite old, so nothing's going to be returned by this.

But I just want to show you that you can pick.

For instance, I got over the last six days, last six weeks, last six months, and you can pick between

the months being a calendar month.

So is it a full calendar month or is it the month from today's date?

So if I pick the last six months and you'll see that basically when return any dates data, because

the data is too old, but it's really useful when you want to have a relative data that is relative

to today.

So let's say, for example, I want to see what happened in the last seven days.

Again, this is not going to return in data, but I'll just say last seven days.

So you can see that this can be quite useful to have, especially when you're working with real time

dashboards where you want to see what's happened in the last seven days or what happened the last two

weeks or what happened in the last three months.

You can easily set those different criteria by being able to add.

This can even say years.

So what happened in the last seven years, for example?

So you get quite a bit of data there.

Okay, So this is going to conclude this lesson and I will see you in the next one.