WEBVTT 00:00.000 --> 00:03.000 Hello friends and welcome to Tutorials Point 00:03.000 --> 00:10.000 In this segment of the video I'm going to show you how to create tables and metrics in PowerVi desktop 00:10.000 --> 00:19.000 Now guys, it's not necessary that every time I create a colorful visualization I'll be able to take any kind of appropriate business decision 00:19.000 --> 00:29.880 Sometimes there might be a scenario where we have to do a visualization in a tabular format in such a way that we can directly see the figures and take an appropriate 00:29.880 --> 00:36.660 business decision so for the same reason we create table and matrix in power BI so guys 00:36.660 --> 00:41.880 how to create this tables and how to create this matrix in power via desktop we'll be having a 00:41.880 --> 00:47.760 better understanding of it in our practical approach hello friends and welcome in this 00:47.760 --> 00:52.760 video we are going to see how to create table and matrix visualization in Power 00:52.760 --> 00:58.600 BI so let's get started off now under the visualization pane if you go here you can 00:58.600 --> 01:06.680 see there is a table visualization and there is a matrix visualization they are just closed next to each other so we'll start off with the table visualization 01:06.680 --> 01:13.240 I will simply select this the moment I click on this you can see there is a blank report with right in front of me 01:13.240 --> 01:16.880 what I need to do is I need to go ahead and add some 01:16.880 --> 01:21.320 data to it so what we will be doing I will go under the product 01:21.320 --> 01:28.280 table and under the product table we have created a hierarchy in which we will select all this category 01:28.280 --> 01:32.780 category one by one that is the category column the segment column and the 01:32.780 --> 01:37.160 manufacturer column so the moment I click on category it is showing me the list of 01:37.160 --> 01:41.540 all the categories and then it is showing me the segments out here and in the 01:41.540 --> 01:46.460 next column it is showing me the list of the manufacturer associated with it 01:46.460 --> 01:53.240 now this is something very textual that means only text can be seen now I would 01:53.240 --> 02:07.860 like to see the revenue as well along with it so I will go on again under the sales fact table and under the sales fact table I select this revenue and drag it here All right the moment I drop it here you can see the revenue for each and every 02:09.160 --> 02:14.060 Manufacture along with the segment and the category can be seen in this third column now 02:14.060 --> 02:21.959 You must be wondering that the report that we have generated is very small even if I increase the size of this particular table. It's not increasing 02:21.959 --> 02:25.940 So how I make the changes I just have to select this a 02:25.940 --> 02:31.120 particular table go under the format tab and under the format tab do you see there's a 02:31.120 --> 02:35.739 value drop-down menu I simply click on it the moment I click on it I can change the 02:35.739 --> 02:40.280 color of my values as of now I do not require that if I want to apply an 02:40.280 --> 02:44.860 alternate font color it's totally up to you with that you want to give it and it 02:44.860 --> 02:48.820 is giving me an option of giving a background color as well if I close 02:48.820 --> 02:53.800 check this dialog box and let's make it little gray so automatically it is 02:53.800 --> 03:01.120 giving a background of little grayish form in an alternate background because it's showing me alternate background color as this 03:01.120 --> 03:08.560 I'll go ahead and select one more lighter shade all right one more okay so this is 03:08.560 --> 03:12.160 what it looks like all right so this is looks imperfect so I have the alternate 03:12.160 --> 03:15.940 shade colors the one thing which we are looking forward for was the text size I'll 03:15.940 --> 03:19.900 simply go into the text size and increase this text size out here so the moment 03:19.900 --> 03:24.260 I increase the text size you can see the text is much more visible right now all 03:24.260 --> 03:30.700 right so this is how easy it is also the for the column headers if you can see the values are greater than the column 03:30.700 --> 03:34.420 header name so I will go under the column headers dropped on menu and increase 03:34.420 --> 03:39.640 its size as well right so making it much more visible for the user to check this 03:39.640 --> 03:43.540 report out so this is what you can do under the table section where I can apply 03:43.540 --> 03:48.820 different kind of formatting different kind of table styles all right let's go 03:48.820 --> 03:52.720 ahead and see the table styles that we have out here if I go into the table style 03:52.720 --> 04:10.540 as of now it is default but if I click on this drop-down menu it is giving me list of all the option that we have out here so minimal will show you the minimum background minimum formatting as we can see out here there not much of a difference I click on this drop menu I get to bold headers so I guess 04:10.540 --> 04:14.739 my headers will get bold yeah that's what it is doing it is taking making my 04:14.739 --> 04:18.820 head is a little bit bolder all right if I click on this drop-down menu let's 04:18.820 --> 04:23.740 contrasting alternate rows we have contrasting alternate rows right so this is what 04:23.740 --> 04:32.120 you can select from a bold header with flashy rows bolded with flash arrows right so you can select the any formatting that you 04:32.120 --> 04:38.419 wish to select from this drop-down menu and get your report then and there itself 04:38.419 --> 04:42.760 alright we'll change back to default because it's looking better than the others 04:42.760 --> 04:47.980 right now in this I would like also like to share that what we else we can do 04:47.980 --> 04:54.580 is in this particular table you can see if I take my cursor right out here the 04:54.580 --> 05:03.700 cursor changes so this is to manual adjust the column size of any column right so if I want to change the column size 05:03.700 --> 05:08.320 if I want to manually adjust it I simply have to go on this particular section 05:08.320 --> 05:14.500 and do it manually with the help of my mouse see how that easy it is if I want to 05:14.500 --> 05:19.060 do it an auto fit I simply have to go there and double click on it it automatically 05:19.060 --> 05:23.919 adjust the column and get me the column width accordingly all right so this is what 05:23.919 --> 05:47.360 I wanted to share now we'll quickly go ahead and see what are the different option that we can see in the matrix table and what is the difference between a matrix table and a normal table all right so I'll simply go ahead and create a matrix visualization all right so it is basically again a table but the only difference out here is that in this matrix I have an option where I can decide that which 05:48.720 --> 05:56.900 what which column need to put in row and which column I need it put in column section so I will be the leader out here and I can 05:56.900 --> 06:09.280 decide what I have to do right so if I we will quickly go ahead and create for different segments let take different segments and that should come along different rows right and I 06:09.280 --> 06:14.780 would like to see what are the years in the columns so I'd like to see the production 06:14.780 --> 06:19.600 or the revenue generated by different segment in different years so two things are 06:19.600 --> 06:23.320 done the last thing which I'll be requiring is the revenue I'll take this revenue 06:23.320 --> 06:27.860 and drag it in values the moment I drag it in values you can see there is a total 06:27.860 --> 06:35.080 which can be seen right at the bottom and we can change it the way you want it right so it is 06:35.080 --> 06:44.920 getting me all the piece of information right in a tabular format now this particular format is 06:44.920 --> 06:51.160 mostly like of a pivot format which we can see in pivot tables in excel where i have different 06:51.160 --> 06:56.920 rows with the all unique values and different columns with all unique values and their 06:56.920 --> 07:02.200 respective revenue out of it right so simply click here and let's see what else we can do 07:02.200 --> 07:07.400 out here in the format section in the format section i have the same general drop-down menu where 07:07.400 --> 07:13.480 i can change the exposition y position manually with the help of these boxes also we have 07:13.480 --> 07:19.800 matrix style out here which gives me the almost a same number of uh styles which we seen in the 07:19.800 --> 07:26.360 previous section for our tables as well let's say take a bowl headers and write something of this sort 07:26.360 --> 07:37.800 or I can get contrasting right contrasting alternate rows or alternate pros that's it so this is how you can create a different kind of reports in 07:37.800 --> 07:44.060 our power BI using the minimum let's go for minimum all right so this is how 07:44.060 --> 07:49.340 you can create a table so this is how you can create a table visualization and 07:49.340 --> 07:56.340 matrix visualization and make the changes accordingly depending on what are the things what we would like to 07:56.340 --> 08:01.960 show the user or the client at the time of the presentation all right guys so this was all about 08:01.960 --> 08:03.800 this video see you until next time