Table Formatting

Step 1: Formatting a report, begin with a table. Choose the following options: Months, Percentage of sales, Quarter, and Sales in billion. In Power View, a table with these fields is displayed.

Step 2: Select any number and then go to the Design tab on the top of the ribbon and then select a percentage from the dropdown list.

Step 3: You can now see that the entire column containing the selected cell is transformed into a percentage.

Step 4: You can also change the font, Theme, and size of the table in power view. For that just go to the Power View tab on the top of the ribbon and from the theme section, you can change it.

Step 5: Here you can see from the theme section we have changed the theme of the table and from the font, we have changed the font from Arial to Georgia.

Step 6: We can also change the size of the table from the Text size on the Themes group. Here, we select the size 150%. By default, the text size is 100%.

Except for the font in a Map Visualization, when you alter the font in one visualization, the same font is applied to other visualizations. Distinct fonts cannot be used for different Visualizations. Individual visualizations, on the other hand, can have their text size changed.

Excel 2013 introduces the Format pane. It offers advanced formatting choices in clean, bright new task windows, and it is also highly useful. When you alter the theme, it is applied to all Power View Views in the Report and Sheets in the Workbook. You may also modify the size of the text in all of your Report Elements. You can add Background Images, alter the Font or Font Size for One Visualization, change the Font or Font Size for the entire page, and Format numbers in a Table, Matrix, etc.

Dataset

This is the major dataset that will be used in this case.