It so before moving forward to our topic things later let's add a couple of slicers in our pages which
we have not done yet.
So this is this year versus last stage table is kind of not complete if we don't have any filter up
here.
So I just had a slicer here and would be in there and I will select it from a dobbed on this last one
we just really do.
OK.
So this is the really Dave Dave slicer.
So let me just make it much more visible by increasing text size.
There you go.
So I would first of all added been directions so this particular is only applicable on this one and
it should not apply on any of these two I would just look for them and this part be good.
This particular visual this particular filter is only applicable for either all of the all of this and
not for this to I have selected for this and none for this.
OK.
Thats how it will work.
So what if I want to play the last one here says and its comparison with the previous years.
So I will from the drop down I was like Lost 1 years ago will I think I have missed something maybe
let me tell them direction.
Oh I see.
So I have none here.
I just click on filter.
There you go.
So the last one here it shows from 2007 does all the ears which are there and it shows the data.
Now I want to see the last two years data I would enter and there you go.
Now I have a little bit of that all in 16 and 17.
So one day here in the dropdown you can select all of these last months.
Lost something is lost something these days or anything with this particular folder or Slessor is applicable
for this one.
Moving on to our page 1 they do we have some room up here as well as we have noticed we have this table
called products which consists of products and that are see the.
So we will use those images as a filter here.
Again we will be using articulate slices.
Let's make this make it this big.
There you go and brain damage.
And the product in that category.
Well let me just make it a little better.
I should be saying that on this and I want to see five it ones that you go and the size of me.
This should be a little bigger maybe 70 or maybe
so it cuts the text of the wise use.
It is perfect.
Now we have our reader here.
So then we click on there you go.
It shows that indeed the Winship saw it is currently selecting multiple products.
If you want to look at this one product click on the formatting pane go to general and just click make
this turn off.
Now you will just select one it at one time or you can drill.
So we have selected drucken but so BUSSAU going to do it offtrack and bus only.
And this is showing I like of all those on your car.
There you go.
So very good rich.
Very rich.
Ready for this.
Ready up here.
Now let's.
What I want to do is I want to add some things lights or things like that.
Is the new updating power which is really neat helpful in thinking the slicers of all the available
apps in your report.
So suppose I have this products slate set up here.
I have this date set up here and I have this sentimentalize set up here so I will put all of those in
this one page.
So just to clear things up.
I cannot use any custom visual like chiclet slicers or any other slice that are available on the market
place only the way you slice it can be used to for the same slice of functionality with the view that
I will have to go to the view pan and check the things slicers.
OK.
There you go.
We have this band up here now.
I will add my first slice of which is my product make it visible for you the there you go.
So now you can see this is my first slice and it shows this particular band shows that it is asking
us to apply the slice or two on many pages so we need to apply these things like that on board page
one and Page two this year.
This I can.
It shows that whether this particular filter should be visible on page one or piece to a specific like
this.
And when I go to page one I will have this as you can see it is available right here.
It will automatically create a filter but I don't want to make this visible.
I just have to uncheck this.
And there you go.
OK so this is our first.
Let's make some more.
I will add maybe the date on it here they go.
Make it place so make your list.
There you go again use the form Mike Bender right here to give the format of this to this one so I have
increased the size of this particular slice.
So I applied the former member here to just like PowerPoint.
Let's make another slide started this will be all over what we can save how much we have used.
We have used our products here.
We have used that.
OK so we can use a sentiment analysis slicer as well so we click here to just to let you know we cannot
really add the image up here for this thing so we need to add the sentiment analysis thing.
Neutral positive or negative but that will work to do that is part 1.
And also we can add something like the country
you go and make it just like this we can slice three ways as well.
OK.
So now we have the slicers ready and all I want is I want to apply this on page one piece to Chad.
I want to play this on page 1 page 2.
There you go.
I want to play this one page one page two.
There you go.
And this one too.
Now we will close this now when I see the pool.
I want to see the details of my plastic guns.
So when I click on page 1 This would show Vellis only of classic cars but I don't know why this is not
swing.
Let's just quickly check if we have done everything right.
So nice like this.
OK.
So for this one I thing I haven't had.
I need to take this one too.
OK.
When I click on this one now you can see only classic cards is shown up here but this is only for cigars.
Pretty good.
Again we want to see the product of my classic car for 2016 and those customers who are very positive
or all like that in United States too.
I hope that all the factors are right on this one.
And I can see all the details in both the pages.
There you go.
This is the customer's
and on Bede's do they go
to.
This is how this whole thing will work.
Just you need to talk of one thing which I haven't done is which is to check this one.
OK.
So I have to check things slicer every.
That here OK.
That's what I thought these things will work.
This was not really working.
Now if I click on page 1 only my 2007 D-plus United States plus classic card data is visible here.
That's all.
All of them is working right from one bit slicer.
So you can see you have to look to 2016.
So automatically it was selected 2016 and all my very happy customers are seen here.
And this is showing that last dollar of all those customers.
And here is the analysis right.
So it's pretty good way to use those things slicers up your all in one pager.
This was a really very highly requested feature from the developers like us.
And so we have now this.
That's how things really work.
I hope you all have understood this.
So we have created this report pretty good.
All they really need is the formatting thing.
OK.
So that's all from this we do.
And keep on learning.
I'll see you in the next game.
Pingu.