Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:05,130 --> 00:00:06,570
Welcome to this lesson.
2
00:00:06,600 --> 00:00:11,310
Now, another topic that I wanted to go through before we concluded the section was the ability to be
3
00:00:11,310 --> 00:00:14,790
able to use your own custom visualizations within Power BI.
4
00:00:15,060 --> 00:00:20,310
So we've got quite a developer network out there who are creating their own visualizations, and you
5
00:00:20,310 --> 00:00:25,050
may well find that some of these visualizations are useful and want to bring them into Power BI.
6
00:00:25,380 --> 00:00:31,860
What I'm going to do first though is I'm just going to set my theme back to my default and go back to
7
00:00:31,860 --> 00:00:33,000
my sales report.
8
00:00:33,300 --> 00:00:37,230
And hopefully here we'll be back to our normal theme.
9
00:00:37,590 --> 00:00:41,490
Now, what we're going to do here is we're going to add a new custom visualization here.
10
00:00:41,490 --> 00:00:44,680
And we're going to we're going to use something called the bullet slicer.
11
00:00:44,700 --> 00:00:47,400
So basically, we've got our slicer at the moment showing a region.
12
00:00:47,400 --> 00:00:51,150
But let's say, for example, that I wanted to show a list of all my countries.
13
00:00:51,180 --> 00:00:56,550
Now I've got quite a lot of countries, and maybe what I want to do is create a slicer that is kind
14
00:00:56,550 --> 00:00:58,010
of like an Excel slicer.
15
00:00:58,020 --> 00:01:02,070
So if you've ever used Excel and you've used the slicer, what you can have is you can actually have
16
00:01:02,070 --> 00:01:05,960
multiple columns and you can then actually have that showing in the columns.
17
00:01:05,970 --> 00:01:10,170
So the chick lit slicer is actually quite a good visualization for showing that.
18
00:01:10,200 --> 00:01:14,880
So I want to add this custom visualization into this power bar report.
19
00:01:15,210 --> 00:01:20,640
And the way that I do that is I actually go into my insert and you'll see that there is an option then
20
00:01:20,640 --> 00:01:23,550
to be able to insert your own custom visualizations.
21
00:01:23,550 --> 00:01:28,680
So we move across here, you'll see that you got your visuals, more visuals, and you'll see that there's
22
00:01:28,680 --> 00:01:32,790
options, that you can get it from the app source or from your own files.
23
00:01:32,820 --> 00:01:38,610
So again, like the themes, it is possible to download some of these files as files that can be uploaded,
24
00:01:38,610 --> 00:01:41,070
but normally it's better to actually go to the app source.
25
00:01:41,070 --> 00:01:42,330
So we're going to select that.
26
00:01:42,780 --> 00:01:48,930
So the pub visual app source is now opened and what you can see is the a large amount of different visuals
27
00:01:48,930 --> 00:01:53,070
that you can actually include into your power by now.
28
00:01:53,070 --> 00:01:58,830
If you were going through this, you'll find that you probably need to look at quite a few different
29
00:01:58,830 --> 00:02:01,110
visuals to get an idea of what they're about.
30
00:02:01,230 --> 00:02:06,270
So if we select one, let's say for example, we select this dial gauge, you click on it and basically
31
00:02:06,270 --> 00:02:10,680
what it will do is it will give you a bit of a preview of what the visual is about.
32
00:02:10,680 --> 00:02:13,890
So I'll give you an explanation telling you what the visuals are.
33
00:02:13,890 --> 00:02:19,100
But also you can see the pricing thread, where it's come from, who's who's done it as well.
34
00:02:19,110 --> 00:02:25,080
What is really nice as well is that you do get certified ones which help you be able to to sort of understand
35
00:02:25,080 --> 00:02:27,480
which ones are quite good and which ones aren't.
36
00:02:27,600 --> 00:02:32,700
Now please note as standard, normally these visuals will work with your current slices, with your
37
00:02:32,700 --> 00:02:36,270
filtering, and they will just easily be brought into this.
38
00:02:36,960 --> 00:02:37,920
So that's really what you do.
39
00:02:37,950 --> 00:02:40,500
You just go through this and you can pick the ones that you want.
40
00:02:40,530 --> 00:02:41,940
You also do get your filters.
41
00:02:41,940 --> 00:02:46,380
So if you want to use some of these filters to be able to find what you're looking for, then you can
42
00:02:46,380 --> 00:02:47,520
use those filters.
43
00:02:47,760 --> 00:02:53,400
However, I have seen the one that I am looking for, and that is the chick lit slicer.
44
00:02:53,430 --> 00:02:58,200
So basically you'll see that you get the chick lit slicer and it gives you an explanation.
45
00:02:58,200 --> 00:03:02,290
And you can see what I can do now is just add it into my beyond.
46
00:03:02,310 --> 00:03:03,570
And that's really what I'm going to do.
47
00:03:03,600 --> 00:03:04,760
I'm going to add this in.
48
00:03:04,770 --> 00:03:09,270
And what it does is it tells me it's imported successfully, which is always good.
49
00:03:09,390 --> 00:03:14,220
Basically, it's now added it as a visual into underneath here.
50
00:03:14,220 --> 00:03:18,480
So you can see you got your traditional list of visualizations we've been working with, but now we've
51
00:03:18,480 --> 00:03:20,220
got the checklist slicer that's been added.
52
00:03:20,960 --> 00:03:21,170
Okay.
53
00:03:21,170 --> 00:03:26,720
I'm going to have quite a bit of data yet, so I'm actually going to use the bottom of this screen to
54
00:03:26,720 --> 00:03:27,520
display it.
55
00:03:27,530 --> 00:03:29,540
Let's let's keep that nice and open.
56
00:03:29,540 --> 00:03:35,210
Now, as I said, what I want to do is I want to be able to create a slicer that is now got all of my
57
00:03:35,210 --> 00:03:35,990
countries in it.
58
00:03:36,320 --> 00:03:38,260
And you see that I can add my categories.
59
00:03:38,270 --> 00:03:42,560
Now, this does give you the ability to work with values and images, but in this case, I'm keeping
60
00:03:42,560 --> 00:03:46,130
it just to the actual countries themselves, going to keep it simple.
61
00:03:46,310 --> 00:03:51,350
So what you can see straight away now is I have my different countries and they've now been displayed.
62
00:03:51,350 --> 00:03:57,110
So if I pick one of these, you can see straight away now that it actually now starts to filter and
63
00:03:57,110 --> 00:04:02,720
you can see that it works like an Excel slicer as you select them and adds it on to the existing list.
64
00:04:02,720 --> 00:04:04,760
To unselect something, you just click it again.
65
00:04:04,760 --> 00:04:08,990
So if I've got Armenia and I've got Italy, I can select Italy just enough.
66
00:04:09,140 --> 00:04:12,020
Or I could take our menu often just select Italy by itself.
67
00:04:12,380 --> 00:04:14,090
It's a pretty easy to use.
68
00:04:14,300 --> 00:04:18,290
But you'll also notice is that you do get your ability to format these as well.
69
00:04:18,290 --> 00:04:21,410
And within the general and within the visual.
70
00:04:21,500 --> 00:04:26,990
So if you want to change the way that this is viewed, you'll see that you do get a different orientation.
71
00:04:27,020 --> 00:04:30,950
I'm actually going to add a see if I can actually give five columns in this.
72
00:04:30,950 --> 00:04:31,370
There we go.
73
00:04:31,370 --> 00:04:32,390
It's not too bad.
74
00:04:33,170 --> 00:04:37,400
But a little bit more height than I could actually see all of the countries.
75
00:04:37,640 --> 00:04:41,000
But I suppose an option is I can make a bit wider and make it six columns.
76
00:04:41,000 --> 00:04:41,590
And there we go.
77
00:04:41,600 --> 00:04:44,690
It's actually now show me all my countries altogether.
78
00:04:44,690 --> 00:04:50,510
So now what it does is it makes it really easy just to be able to pick and choose which countries.
79
00:04:51,140 --> 00:04:55,760
And again, you can see due on multiple selection on if I turn that off, then hopefully now you'll
80
00:04:55,760 --> 00:04:59,990
see that it only allows me to choose one option that's pretty useful.
81
00:05:00,960 --> 00:05:02,300
We can turn that on.
82
00:05:02,480 --> 00:05:05,060
Can also then say, How do you want this to be viewed?
83
00:05:05,060 --> 00:05:06,290
So you check it itself.
84
00:05:06,290 --> 00:05:09,860
What's your text size to the I can make it a little bit smaller as well.
85
00:05:09,890 --> 00:05:11,270
What's the height that you want to use?
86
00:05:11,270 --> 00:05:13,120
Do you want to make bigger or smaller here?
87
00:05:13,160 --> 00:05:16,610
In this case, I do have a bit of extra space so I could make it a bit higher.
88
00:05:16,610 --> 00:05:17,360
Your width.
89
00:05:17,780 --> 00:05:19,460
Do you want a specific background color?
90
00:05:20,180 --> 00:05:24,380
You can create the background color on there or keep it as what?
91
00:05:25,170 --> 00:05:28,170
What is your selection color so basic when it's selected.
92
00:05:29,860 --> 00:05:31,360
And again, we say that.
93
00:05:31,570 --> 00:05:34,300
So we now know it's when it's selected.
94
00:05:34,450 --> 00:05:38,880
And if you wanted to, you could have hover colors and you can see there's quite a few options there.
95
00:05:38,890 --> 00:05:45,010
So just like any other visualization, it allows you now to be able to make any changes that you want.
96
00:05:45,520 --> 00:05:46,060
Okay, great.
97
00:05:46,060 --> 00:05:50,890
So we've now got that selected and it's now part of our sales report.
98
00:05:50,980 --> 00:05:53,110
So let's see what happens in the air service.
99
00:05:53,110 --> 00:05:55,930
If we publish this, is it going to work in the air service?
100
00:05:56,470 --> 00:05:57,610
So we're going to go back.
101
00:05:57,610 --> 00:06:00,310
We're going to actually save this and we're going to publish it.
102
00:06:00,310 --> 00:06:02,500
So let's first of all, just go to the top.
103
00:06:02,500 --> 00:06:05,620
We're going to save this and let's go back to our home.
104
00:06:05,890 --> 00:06:08,320
Let's choose our publish option again.
105
00:06:08,320 --> 00:06:10,960
I'm going to publish into training and we're going to select that.
106
00:06:10,960 --> 00:06:13,300
It's going to tell me it's going to replace an existing report.
107
00:06:13,300 --> 00:06:14,170
That's fine.
108
00:06:14,290 --> 00:06:15,550
We'll replace that.
109
00:06:16,000 --> 00:06:16,100
Okay.
110
00:06:16,180 --> 00:06:17,200
We'll give that a bit of time.
111
00:06:17,200 --> 00:06:18,850
Just let it finish the publishing.
112
00:06:19,780 --> 00:06:20,580
So good news.
113
00:06:20,590 --> 00:06:21,100
Success.
114
00:06:21,100 --> 00:06:22,930
We've now published that successfully.
115
00:06:22,930 --> 00:06:26,530
Let's go back into the Power Air Service and let's view this report.
116
00:06:27,410 --> 00:06:27,650
Okay.
117
00:06:27,650 --> 00:06:27,890
Right.
118
00:06:27,890 --> 00:06:29,330
We're back in the pub service.
119
00:06:29,330 --> 00:06:30,440
We're back on the home page.
120
00:06:30,440 --> 00:06:32,120
So let's go to our workspace.
121
00:06:32,720 --> 00:06:34,790
We're going to go to our training workspace.
122
00:06:34,790 --> 00:06:38,000
And in this case, now we're going to choose our sales report again.
123
00:06:38,540 --> 00:06:40,220
All right, So there's our sales report.
124
00:06:40,220 --> 00:06:41,030
And there we go.
125
00:06:41,030 --> 00:06:41,570
Good news.
126
00:06:41,570 --> 00:06:45,110
There's our countries and we select our countries.
127
00:06:45,410 --> 00:06:50,390
We can see now that it is doing not filter very easily.
128
00:06:51,040 --> 00:06:51,780
So there we go.
129
00:06:51,790 --> 00:06:56,740
We've now brought a custom visualisation into our Power BI desktop and we've now published it to the
130
00:06:56,740 --> 00:06:58,000
pub, your service.
131
00:06:58,360 --> 00:06:59,880
Okay, We're going to conclude the lesson there.
132
00:06:59,970 --> 00:07:01,060
I will see you in the next one.
12692
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.