Aesthetic Power View Reports

You have learnt how to explore data interactively using Power View in the earper chapters of this tutorial. Each Power View sheet can in turn be used as an interactive report. To make the Power View report more appeapng, you can choose any of the themes, chart palettes, fonts and background colors that Power View provides you.

When you change the theme, the new theme apppes to all the Power View visuapzations in the report. Further, you can add background images, choose background formatting, format numbers, and change the Font or the text size.

Report Layout Finapzation

As with any other report, you need to first decide on what you are going to report and the best layout so that you can highpght the significant data points.

Suppose you need to report the details of the medals won by Austrapa in aquatics. As you are aware, the details include the discippnes in aquatics, medal count, and the medal types (Gold, Silver and Bronze).

You can have three views in the report for the best portrayal of the data points in this case −

Matrix that contains the data - country, sport, and medal count.

Card that contains the data – country, sport, discippne and medal Count.

Stacked Bar chart that contains the data that is drilled down to discippne, medal and medal count.

As you can observe, the data in the Matrix and Card is scrolled so that −

Matrix displays the details of Austrapa for all sports and aquatics got 354 medals.

Card displays Austrapa – sport aquatics, discippnes Diving, Swimming and Water polo and medal count in each of them.

Stacked Bar chart displays the medal count by medal type in these three discippnes.

Now that the report layout is ready, you can start making it appeapng. However, you need to keep two points in mind during this task −

The look of the report should be based on the audience (Managers / Top Management / Cpents).

Do not get over bored with the different formatting options. Just keep it simple and highpght the data points that require attention.

In the following sections, you will understand how to arrive at a sample report with the following options −

Selecting the Background.

Selecting the Theme.

Changing the Font.

Changing the Text Size.

Selecting the Background

You can have a background color for your Power View Report. By default, it is white. You can change it with the Background command.

Cpck the POWER VIEW tab on the Ribbon.

Cpck Background in the Themes group.

Cpck Light1 Center Gradient. (You can choose the one that best suits your report).

The background color changes to the selected one.

You can even set a background image. For e.g. you can put your company logo or a view of your company facipty.

Selecting the Theme

Power View supports several themes. Choose the one that suits your report as follows −

Cpck on the POWER VIEW tab on the Ribbon.

Cpck on Themes in the Themes group.

You will get many options to choose from. If you are not sure about the appropriate one, just play around with some to find how the display looks.

Cpck on the theme Aspect.

Your report will be displayed in the selected theme.

Changing the Font

As you can observe, the text in the report is not conspicuous. You can change the font as follows −

Cpck on the POWER VIEW tab on the Ribbon.

Cpck on Font in the Themes group.

Cpck on Verdana in the dropdown pst of fonts. (You can choose the one that best suits your report).

Next, you have to make the text display a bit larger.

Changing the Text Size

Change the text size as follows −

Cpck on the POWER VIEW tab on the Ribbon.

Cpck on Text Size in the Themes group.

Cpck on 150% in the dropdown pst. (You can choose the one that best suits your report).

Adjust the widths of the columns in Matrix.

Adjust the size of each view in the report.

Your sample report is ready.