Power BI - Table styles

Hello, friends and welcome

Now in our previous video we have already seen that how to create tables and metrics, right

Now in this video I'm going to show you how to give the table styles and what are the different

table styles that are available with PowerBi. Now once you have created the table, you simply have to go under the format section

and under that format section you can have the bunch of options which you can choose from

where you can give the background color, change the text, text alignment change the text size change the text font as well and create a better table

style in such a way that it looks appealing for the people or to the user who will be viewing

that particular report so let's go ahead and see how to give different kind of table styles

in our practical approach hello friends and welcome in this video we are going to see what

are the different table styles are there in power bi and how to apply them to a particular

table projection all right so we will quickly go ahead and see how it is done

now for the same reason what I've done I have pulled out the same report that

we have pulled out for our previous video that is while creating a table

right so while creating this particular table format I have used the same

example in which I'll be having different categories segment manufacturer and its revenue all right now as we have already created the table let's quickly

go ahead and see how the formatting does take place all right in order to do the

formatting I have to move to the format pane out here and simply click on it now

under this format pane you can see the bunch of options that are available with us

now let me tell you quickly that how it is done and now I will start off with

this value section the reason being I would like to see the values inside this

particular table in a certain font let's say it should be not

that big or it should be not that small and how I decided I have simply have to go

under this value drop-down menu and select the text size of this particular text

so if I increase it it will give a bigger text right and if I decrease it it will give me a text of my font right So let keep it till 12 so that it is visible for everyone

All right. Also, we can go ahead and increase the column header size as well so that it matches up with the value size

So in order to do that, I will go under the column headers. And under the column headers, you can see there is an option to increase the text size

we will make this dwell as well alright there is various other option in which I can

select the background of the column headers the font of the ball column headers with

the help of this drop-down menu under the column header section so let's say

that I will give it a format let's say a light yellowish format at the behind

right so this is giving me a light yellowish background at the column headers also if

I wish to change the text of font colors I can take it

change it from here but the black and yellow combination looks good as of now so I

will not change it I'll keep it as simple as I can alright now there is something

called as table style with the help of which I can also change the color of the

table with a different color combination right if I would like to check that I

will simply click on this table style drop-down menu and under this I have style

as of now it is default which means there is no heavy formatting given to this

set of entries all right so in order to change this particular style I will

simply click on this drop-down menu and which I will be seeing a bunch of

option which I can select ROM so if I select minimal it sarà it will

showing them as minimum bare barely minimum any formatting being applied out

here so that's the what about minimal what it does if I move on with the next

one that is bold headers it will give you headers in a bold category and it is

giving a background color as black by default. I can also change this colors if I go under the column header common and if you see as of now

the background color is black and the font color is white, I can simply change from here

as well and change the background color according to my own need So it not necessarily that the style that you give out here and the color combination that is present out here will be constant no we can definitely change it by hovering around the different

styles that we are going to apply all right quickly I'll go to showing you

contrasting alternate rows so I have contrast alternate rows a little bit flashy all right if I click on this drop-down menu and

Klikon Sparse so basically I'm getting a normal layout report layout with a darker

column header and the total header right so this is how you can change the styles that

we are having at us in the table style drop down menu all right you can also

select different we can also apply different kind of conditional formatting to this

particular data set by just going under this fields pane and under this field

I see something called as revenue if I click on the drop down of the revenue you see

there's an option call as conditional formatting so we can set a certain condition

upon upon what color that they are carrying upon what values they are having

let's start off with the background color scales and see what it does so I say

background color scales so it should be based on the revenue value color by the

rules if you apply the rule and it the colors is being being applied it will only

show the color and not the values inside it. I would also like to see the value so

that's the reason I kept it unchecked. Now out here it is starting from the bare

minimum so the minimum value will be represented by the color pinkish and the maximum

value will be represented by this blue color. Now there is an option of diverging

as well now see what happens if I click on this checkbox for diverging the moment I

click on this divergent box you can see a center is also being added so that

that I can get three varieties of color that is pinkish blue yellow I'm sorry and blue

right so I can determine that which value should be the which value should be in

yellowish which value should be in lowest and which value should be in highest I can also mention it by the number by mentioning the number selecting the drop menu for the number and select giving the value let say 1 or 10 or 1 lakh depending on what is your

data set is talking about right so we can be specific whether which number is

representing which color or we can directly go on this drop-down menu and select

highest value so it gives you the color accordingly. The moment I hit okay now you can

see there is a change color in the revenue drop-down revenue column right so you out here you can

simply see that for the minimum it is a little orangeish though for the for the

made that is the middle one it is orangeish for the minimum it is pinkish and if we

have yes the green one which is the most highest that is when I'd sell manufacturer

has given the maximum amount of revenue in this particular segment and category

Alright, so this is how you can apply conditional formatting in various range. I click on this drop-down menu go to conditional formatting again

There is something called as data bars as well there's something called as font color scales as well

Let me quickly show you what does this data bars is doing so I will simply click on this data bars

It is showing the lowest value would be a And lowest value to the highest value. Lowest value will be in the

Positive bar that will be in blue and the negative bar will be in red and this will be my axis

okay let's sit okay now you can see the data bars are being applied to some of the

section right so it is picking up the highest range and comparing it with the

every value in this particular column so it will automatically put out the highest

that is the maximum from this range and in compared to that maximum value how the

rest of this records or rest of the entries are giving me the performance right

so this is how you can introduce data bars you can apply conditional

formatting and make your table as attractive as can as beautiful as you can so that it looks very much appealing to the user who are using it all right guys so this is how you can apply different kind of styles to your table and that's what we have learned in this video

So hopefully you guys like this video see you until next time