You have learnt how to explore data interactively using Power View in the earlier chapters of this tutorial. Each Power View sheet can in turn be used as an interactive report. To make the Power View report more appealing, 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 applies to all the Power View visualizations in the report. Further, you can add background images, choose background formatting, format numbers, and change the Font or the text size.
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 highlight the significant data points.
Suppose you need to report the details of the medals won by Australia in aquatics. As you are aware, the details include the disciplines 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 −
As you can observe, the data in the Matrix and Card is scrolled so that −
Matrix displays the details of Australia for all sports and aquatics got 354 medals.
Card displays Australia – sport aquatics, disciplines 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 disciplines.
Now that the report layout is ready, you can start making it appealing. 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 / Clients).
Do not get over bored with the different formatting options. Just keep it simple and highlight the data points that require attention.
In the following sections, you will understand how to arrive at a sample report with the following options −
You can have a background color for your Power View Report. By default, it is white. You can change it with the Background command.
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 facility.
Power View supports several themes. Choose the one that suits your report as follows −
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.
Your report will be displayed in the selected theme.
As you can observe, the text in the report is not conspicuous. You can change the font as follows −
Next, you have to make the text display a bit larger.
Change the text size as follows −
Click on the POWER VIEW tab on the Ribbon.
Click on Text Size in the Themes group.
Click on 150% in the dropdown list. (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.