Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

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...