Power View – Self-service Reporting - Reporting with Microsoft SQL Server 2012 - page 91

View preview images
As mentioned in the Deploy and share reports section, if you save the preview images
when saving the report, they will be displayed in the View pane in the design mode.
Chart highlighting, slicers, and filtering
Power View provides different ways to filter and highlight data in reports. Since
the underlying data model contains metadata, Power View knows the relationships
between the various tables and fields in a report, so one visualization can be used to
filter all the other visualizations. Chart highlighting, slicers, and filters are three of
the ways to filter all the visualizations in a view in Power View (SharePoint) or all
the visualizations in a sheet in Power View (Excel). You can choose to create filters
for the whole view or sheet or for individual visualizations. None of these filters
apply across the whole report: in Power View in SharePoint, they are specific to
individual views in the report. In Power View in Excel, they are specific to individual
sheets in the report. All of the filters allow you to select one or more values.
Chart highlighting
Charts can act as filters via interactive cross-filtering. When you select a value
by clicking directly on the chart, it will filter the values in all the tables, titles,
and bubble charts in the view or sheet based on the value you clicked on. It also
highlights parts of the charts that pertain to the value, showing the impact of the
filtered values on the original values. You can select multiple values by using Ctrl +
left-click. To clear a filter, click inside the background of a report item, not on a value.
Interactive cross-filtering selections are saved when you move from one view or
sheet to another, but are not saved with the report.