Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,000 --> 00:00:01,000
Instructor: All right,
2
00:00:01,000 --> 00:00:03,000
so we've kind of mentioned this topic already,
3
00:00:03,000 --> 00:00:07,000
but if a report page has a number of slicers,
4
00:00:07,000 --> 00:00:09,000
you could add an apply all slicer button
5
00:00:09,000 --> 00:00:12,000
to your report page that basically tracks all
6
00:00:12,000 --> 00:00:14,000
of the slicers and can either apply,
7
00:00:14,000 --> 00:00:17,000
or clear all of those slicers with a single click.
8
00:00:17,000 --> 00:00:20,000
The biggest reason for this is the reduction
9
00:00:20,000 --> 00:00:23,000
in the total number of visual queries that are being made.
10
00:00:23,000 --> 00:00:26,000
You're transforming multiple visual queries
11
00:00:26,000 --> 00:00:28,000
that are coming from each of the slicers,
12
00:00:28,000 --> 00:00:31,000
and combining them into a single query.
13
00:00:31,000 --> 00:00:34,000
So again, it's really all about performance optimization.
14
00:00:34,000 --> 00:00:36,000
All right, so when you click on
15
00:00:36,000 --> 00:00:37,000
the apply all slicers button,
16
00:00:37,000 --> 00:00:42,000
a new blank unformatted button is added to the report page,
17
00:00:42,000 --> 00:00:44,000
just like what you're seeing on the slide here.
18
00:00:44,000 --> 00:00:47,000
And again, the main reason why you're adding this button
19
00:00:47,000 --> 00:00:50,000
is to be able to apply all of the slicers
20
00:00:50,000 --> 00:00:53,000
within a single click or clear all of the slicers
21
00:00:53,000 --> 00:00:54,000
in a single click.
22
00:00:54,000 --> 00:00:57,000
Keep in mind that this button will impact all
23
00:00:57,000 --> 00:00:59,000
of the slicers within a report page,
24
00:00:59,000 --> 00:01:01,000
and you can't really pick or choose
25
00:01:01,000 --> 00:01:03,000
which slices are impacted.
26
00:01:03,000 --> 00:01:06,000
It's really just an all or nothing approach.
27
00:01:06,000 --> 00:01:09,000
Now, some of the other important pieces to consider here
28
00:01:09,000 --> 00:01:11,000
are that you can actually have multiple apply all,
29
00:01:11,000 --> 00:01:14,000
or clear all slicer buttons within a page.
30
00:01:14,000 --> 00:01:16,000
And this comes in really handy when you want to add them
31
00:01:16,000 --> 00:01:19,000
in different locations or add to a filter pane
32
00:01:19,000 --> 00:01:22,000
that's collapsible like we built in this project.
33
00:01:22,000 --> 00:01:25,000
And these buttons can be formatted just like any
34
00:01:25,000 --> 00:01:27,000
of the other buttons in Power BI.
35
00:01:27,000 --> 00:01:28,000
So feel free to get as creative
36
00:01:28,000 --> 00:01:31,000
as you want and match this apply,
37
00:01:31,000 --> 00:01:34,000
or clear all slicers button to your report theme and layout.
38
00:01:34,000 --> 00:01:35,000
So just to mention this,
39
00:01:35,000 --> 00:01:37,000
we're not really gonna work through adding one
40
00:01:37,000 --> 00:01:40,000
of these slicers into our Power BI report.
41
00:01:40,000 --> 00:01:42,000
Honestly, it's really straightforward.
42
00:01:42,000 --> 00:01:44,000
You've already created a bunch
43
00:01:44,000 --> 00:01:46,000
of different buttons throughout this course,
44
00:01:46,000 --> 00:01:48,000
and this really isn't much different.
45
00:01:48,000 --> 00:01:50,000
So again, this is just a fun exercise
46
00:01:50,000 --> 00:01:51,000
that you can work through on your own.
47
00:01:51,000 --> 00:01:54,000
But what I would like to do is kind of talk
48
00:01:54,000 --> 00:01:57,000
through a scenario here and pretend that we have
49
00:01:57,000 --> 00:02:00,000
a report that has 10 core visuals on it,
50
00:02:00,000 --> 00:02:03,000
and we've added four slicers that are built
51
00:02:03,000 --> 00:02:04,000
into a slicer pane.
52
00:02:04,000 --> 00:02:09,000
So we've got 14 items in total, 10 are visuals,
53
00:02:09,000 --> 00:02:10,000
and four are slicers.
54
00:02:10,000 --> 00:02:15,000
Now, every time you select a value within a slicer,
55
00:02:15,000 --> 00:02:19,000
those 10 non-slicer visuals will change based
56
00:02:19,000 --> 00:02:21,000
on the selection that's made.
57
00:02:21,000 --> 00:02:24,000
So let's say that you select two options
58
00:02:24,000 --> 00:02:28,000
from the first two slicers, three from the third slicer,
59
00:02:28,000 --> 00:02:31,000
and one option from the fourth slicer.
60
00:02:31,000 --> 00:02:34,000
In total, you've made eight selections,
61
00:02:34,000 --> 00:02:37,000
which then need to propagate to the visuals,
62
00:02:37,000 --> 00:02:40,000
but keep in mind that it's just not eight selections,
63
00:02:40,000 --> 00:02:45,000
it's eight selections from slicers times 10 visuals.
64
00:02:45,000 --> 00:02:49,000
So we've got 80 visual queries that need to be updated,
65
00:02:49,000 --> 00:02:52,000
and it's highly likely that many of those are unnecessary,
66
00:02:52,000 --> 00:02:54,000
or they're competing.
67
00:02:54,000 --> 00:02:56,000
So if you had used an apply all slicers button,
68
00:02:56,000 --> 00:02:58,000
you could actually bring that total
69
00:02:58,000 --> 00:03:02,000
from 80 down to just eight visual queries.
70
00:03:02,000 --> 00:03:04,000
Again, that's gonna significantly improve
71
00:03:04,000 --> 00:03:06,000
your report performance.
72
00:03:06,000 --> 00:03:10,000
Again, there's always outliers in extenuating circumstances,
73
00:03:10,000 --> 00:03:12,000
but I just wanted to kind of use this example
74
00:03:12,000 --> 00:03:15,000
to demonstrate why this feature is super important
75
00:03:15,000 --> 00:03:18,000
when you've added multiple slicers within a page.
76
00:03:18,000 --> 00:03:19,000
All right, up next,
77
00:03:19,000 --> 00:03:22,000
we're gonna dig into the performance analyzer a little bit.
6229
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.