Customizing Your Power View
Let’s modify our list by doing the following actions:
- Filter out the 2013 dates.
- Remove the Sales % field.
- Change the summary line into averages instead of totals.
- Turning the rest into a bar chart.
To filter out the dates, we will click and drag the ‘Date’ field from the Field list into the Filters area. Next, we will select All dates and then remove any of the 2013 dates. As you can see in Figure 3 we have removed the 2013 dates.
Next, we will remove the Sales % field by simply unchecking the field in the Power View field list.
To change the summary line in the report to averages, we click the drop down box next to the Fields in the bottom section of the Field list. The summary line in the report will be updated as you change the fields over to the average value (Figure 4). Since the average is not a whole number in most cases, we can use the ‘Decrease Decimal’ button on the Design tab to remove the decimal places. Next, we’ll turn the resulting data into a chart. Click anywhere within the report area and click the Design menu. Next, click on Bar or Column chart and choose the right chart for you. Your lackluster table should now be a great looking chart.
The great thing is that you can now give this report to someone to analyze and they will be able to utilize the filters to only report on the data they want to see. No need for them to understand the underlying data.
Power View can be used to produce some extremely powerful interactive charts and visualizations without forcing users to understand how the underlying data is structured. As this article just touched the surface when it comes to Power view, don’t be afraid to test some of the more advanced functionality!