Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:05,630 --> 00:00:06,740
Conclude the section.
2
00:00:06,740 --> 00:00:11,900
I just want to spend a couple of lessons on some changes and updates that we can do with our Power BI
3
00:00:11,900 --> 00:00:16,190
desktop, just to help you with some of the formatting and some of the things that you can do.
4
00:00:16,520 --> 00:00:21,350
So far I've spoken throughout the course to say that you can actually change the theme and you can change
5
00:00:21,350 --> 00:00:23,330
the default colors that you're working with.
6
00:00:23,450 --> 00:00:23,690
Now.
7
00:00:23,690 --> 00:00:27,500
I've been using the sort of default colors because hopefully on the training course most people would
8
00:00:27,500 --> 00:00:28,910
have access to those.
9
00:00:28,910 --> 00:00:33,590
But let's have a look and see if you wanted to change your theme, how you'd go about that.
10
00:00:33,920 --> 00:00:38,990
So we're back in the Power BI desktop and what we're going to do is we're going to go to our view and
11
00:00:38,990 --> 00:00:40,820
you'll see there's an option called themes.
12
00:00:40,820 --> 00:00:46,520
And what you'll see is this is very much like a sort of Microsoft Office type of option.
13
00:00:46,520 --> 00:00:50,600
When you come into it, you pick a style and the style then gets applied according to that.
14
00:00:50,600 --> 00:00:54,920
So you can see at the moment that you've got your current theme that's been used, the default theme.
15
00:00:54,920 --> 00:00:59,090
However, if you go to your Power BI, you will see that there's different themes that you can use as
16
00:00:59,090 --> 00:01:01,430
defaults and you can experiment with these.
17
00:01:01,430 --> 00:01:06,950
You can try the different colors, see if there's any that actually you like and that you could use
18
00:01:06,950 --> 00:01:07,820
in your report.
19
00:01:08,220 --> 00:01:10,820
There's a few interesting options that you could use.
20
00:01:11,150 --> 00:01:14,570
So basically I'm just clicking and you can just see just trying different options.
21
00:01:14,570 --> 00:01:18,710
And as you can see, the reports getting updated with that theme option.
22
00:01:19,950 --> 00:01:24,270
So you can experiment with the different colors and the different themes that are the defaults for the
23
00:01:24,270 --> 00:01:25,020
power beer.
24
00:01:25,050 --> 00:01:28,140
However, we do have other options that we can do as well.
25
00:01:28,170 --> 00:01:31,610
And one of the things that we can do is we can go to something called a theme gallery.
26
00:01:31,620 --> 00:01:37,170
So what's happened over time is that certain people have put together their own themes and then they've
27
00:01:37,170 --> 00:01:41,010
been published on the theme gallery on Microsoft Power BI.
28
00:01:41,190 --> 00:01:42,480
So we're going to visit that.
29
00:01:42,480 --> 00:01:43,770
It's actually on the Internet.
30
00:01:43,770 --> 00:01:46,890
So I'm going to click on Theme Gallery and we're going to see our browser open.
31
00:01:47,550 --> 00:01:53,790
So you can see now that the browser is opened and we now looking at the theme gallery because it's part
32
00:01:53,790 --> 00:01:55,620
of the Microsoft Power BI community.
33
00:01:56,070 --> 00:02:00,270
So you can change this and you can look at the recently posted or the featured ones.
34
00:02:00,280 --> 00:02:05,640
If you wanted to look at featured options and see the different featured options that are available,
35
00:02:06,030 --> 00:02:07,890
the ones that receive the top kudos.
36
00:02:08,820 --> 00:02:09,479
Also.
37
00:02:10,539 --> 00:02:16,270
So go back to recently posted so you can go through this and you can have a look at different styles
38
00:02:16,270 --> 00:02:19,000
and then decide which ones you quite like.
39
00:02:19,030 --> 00:02:24,700
So say for example, you are kind of liking this executive report, say as an option.
40
00:02:24,700 --> 00:02:25,810
So if we click on that.
41
00:02:26,520 --> 00:02:30,570
It will then open this up and it will show you what it looks like in your power pie.
42
00:02:30,600 --> 00:02:34,680
So it gives you an example of the different styles that can be used.
43
00:02:35,370 --> 00:02:36,330
As you can see.
44
00:02:37,660 --> 00:02:39,550
This is a different style that you've got.
45
00:02:41,460 --> 00:02:47,070
And if you get down from this, you will then see that there is a theme JSON file.
46
00:02:47,220 --> 00:02:49,280
Now the JSON file is the key file.
47
00:02:49,290 --> 00:02:53,940
So if you downloaded this themed JSON file, basically select the download.
48
00:02:54,060 --> 00:02:58,310
If we go back into our power BI, I'm going to bring up our Power BI desktop.
49
00:02:58,320 --> 00:03:03,780
So I'm back in the Power BI desktop now and all you would do is then you would browse for the theme
50
00:03:03,780 --> 00:03:08,910
and basic you would select that saved theme as a file and you would upload that JSON code.
51
00:03:08,910 --> 00:03:13,080
And that's basically what the theme is doing, is saving the theme as a JSON code.
52
00:03:13,080 --> 00:03:17,250
So at any time you can actually just produce your own JSON code, you could actually produce that and
53
00:03:17,250 --> 00:03:20,250
actually bring that into PA, it would work.
54
00:03:20,640 --> 00:03:24,690
So there's one option you can do is you can go out there, you can see other people's work, you can
55
00:03:24,690 --> 00:03:27,400
download their JSON files and then upload them.
56
00:03:27,420 --> 00:03:31,110
The other option that you've got though, is you can actually customize your current theme.
57
00:03:31,110 --> 00:03:36,000
So I'm just going to go back to my default and let's go back to customize current theme.
58
00:03:36,240 --> 00:03:41,490
So when you select this, it will now give you a ability to come into this and then to be able to change
59
00:03:41,490 --> 00:03:43,050
your different theme options.
60
00:03:43,320 --> 00:03:45,810
And the first part is you need to give this a name.
61
00:03:45,810 --> 00:03:53,040
So let's say I'm going to call this my theme one and you get your names and colors.
62
00:03:53,040 --> 00:03:55,320
So let's say I don't really like this blue color.
63
00:03:55,350 --> 00:03:58,140
Maybe I want that to be a little bit lighter to begin with.
64
00:03:58,800 --> 00:04:01,470
Let's say with color two, I actually want a greenish color.
65
00:04:01,470 --> 00:04:03,270
Let's say I want a dark ish green.
66
00:04:03,660 --> 00:04:06,210
And we go that color, say color three.
67
00:04:06,210 --> 00:04:08,010
I want a more reddish color.
68
00:04:09,300 --> 00:04:17,940
Maybe move that over to so orange, I get to use a red color there and you get the idea you go through
69
00:04:17,940 --> 00:04:19,800
now with your different colors.
70
00:04:19,800 --> 00:04:23,370
And when I click on the apply, you will see now that the color scheme has changed.
71
00:04:23,370 --> 00:04:26,340
Now to use those colors so you can see the light blues.
72
00:04:26,340 --> 00:04:28,890
They're the greens, they're the reds that I've just used.
73
00:04:28,890 --> 00:04:31,230
So those colors would then be used.
74
00:04:31,320 --> 00:04:32,430
There's quite a lot to this.
75
00:04:32,430 --> 00:04:37,500
So if we go back to customize current theme, the first one in here is obviously you can change the
76
00:04:37,500 --> 00:04:42,120
default colors that are used, but also then you could decide in your sentiment colors.
77
00:04:42,120 --> 00:04:45,360
Also using diverging colors, you can set those as defaults.
78
00:04:45,510 --> 00:04:48,210
Now, there are quite a lot of options here, so I'm just going to run through them quickly.
79
00:04:48,210 --> 00:04:50,490
Just to get an idea in, you advanced as well.
80
00:04:50,490 --> 00:04:51,300
You can see that.
81
00:04:51,300 --> 00:04:56,220
What's your colors for your different elements in your visual like access grid lines, text fonts,
82
00:04:56,220 --> 00:05:00,120
And in this case you'll see that you're not really using a true black.
83
00:05:00,120 --> 00:05:04,890
So I would definitely suggest that going and trying to set this as a true black, there we go.
84
00:05:04,890 --> 00:05:09,930
000 said that as a true black and said that as my first level.
85
00:05:09,930 --> 00:05:14,640
And if you wanted to use second level elements as well, you could come and maybe make those just a
86
00:05:14,640 --> 00:05:17,340
little bit darker if you wanted to.
87
00:05:17,370 --> 00:05:20,910
So as you can see, they've got a bit of a gray scale here, but I definitely suggest on your first
88
00:05:20,910 --> 00:05:23,700
level elements, you would want that to be a true black.
89
00:05:23,970 --> 00:05:24,900
The same with your text.
90
00:05:24,900 --> 00:05:29,400
Actually, your once we go into text here, you got your general text, you can see you can change your
91
00:05:29,400 --> 00:05:33,180
font family, the font size in this case as well your font color.
92
00:05:33,180 --> 00:05:38,370
I would drag this down and make it a true black in terms of being able to see that.
93
00:05:38,370 --> 00:05:40,380
And you can see with your title as well.
94
00:05:40,620 --> 00:05:45,990
And again, I would use a true black for that cards and KPIs which are default.
95
00:05:46,020 --> 00:05:53,010
You might remember that I was using more like around the size 27 for this in terms of points and then
96
00:05:53,040 --> 00:05:54,690
again our true black.
97
00:05:54,870 --> 00:06:01,290
So I think you're getting the idea and we can set all of these options here in your visuals as well.
98
00:06:01,290 --> 00:06:04,620
You can have different default background colors if you wanted.
99
00:06:04,620 --> 00:06:07,560
What is your border you could ever set to default beyond?
100
00:06:07,590 --> 00:06:13,050
Remember, I was kind of using more of a dark gray for my border so I could set that as my my border
101
00:06:13,050 --> 00:06:13,410
there.
102
00:06:13,410 --> 00:06:19,860
And also I used my 15 pixels as the radius in the headers as well, which your background colors, your
103
00:06:19,860 --> 00:06:22,260
transparencies, your tooltips as well.
104
00:06:22,260 --> 00:06:24,900
What's the default that you would want to use for this?
105
00:06:25,170 --> 00:06:27,270
And then we have our pages as well.
106
00:06:27,270 --> 00:06:32,910
If you're using a specific page background, like for instance, you may want to use like a little bit
107
00:06:32,910 --> 00:06:38,010
of a gray background, for example, and maybe not have any transparency.
108
00:06:38,550 --> 00:06:39,990
You're full to pain as well.
109
00:06:39,990 --> 00:06:45,090
So the filter pane, we've already seen that our filters over here, how you would want that to be.
110
00:06:45,090 --> 00:06:49,350
So as you can see, there's a number of different options that you can come through and customize here.
111
00:06:49,620 --> 00:06:50,400
Aren't you happy with it?
112
00:06:50,400 --> 00:06:57,120
You click apply and you can see now that it's now updated the report to to show that now, because my
113
00:06:57,120 --> 00:07:02,580
board is on, do you see that it's actually now applied the border to my heading and maybe in certain
114
00:07:02,580 --> 00:07:05,490
situations I might not want it to actually do certain things.
115
00:07:05,490 --> 00:07:08,130
So just turn that back off again.
116
00:07:08,880 --> 00:07:12,960
But you get the idea you would come through this and you may need to make some changes.
117
00:07:12,960 --> 00:07:15,960
But you can see now that the background color for the page has changed.
118
00:07:16,230 --> 00:07:21,150
And basically all that's happened now is that it's now saying in this report that the current theme
119
00:07:21,150 --> 00:07:22,740
is the my theme one.
120
00:07:23,220 --> 00:07:28,890
Now, if I wanted to use this for other reports, what I can do is to save the current theme, save
121
00:07:28,890 --> 00:07:33,990
it as a file, and then go into other reports, upload that theme, and then apply it.
122
00:07:33,990 --> 00:07:37,230
So it can be very powerful for for being able to do that.
123
00:07:38,070 --> 00:07:40,780
So hopefully this has given you a bit of an idea around themes.
124
00:07:40,800 --> 00:07:45,990
I've just shown you a bit of a basic overview here, but it's definitely something to experiment with
125
00:07:45,990 --> 00:07:50,640
and if you're using your lot, you will find that this will save you a lot of time in terms of setting
126
00:07:50,640 --> 00:07:54,660
a default that really works for you, and then you can just apply it to other reports.
127
00:07:54,960 --> 00:07:56,290
We're going to conclude the lesson there.
128
00:07:56,330 --> 00:07:57,420
I'll see you in the next one.
13490
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof