Time for action – using Filter in Power View

In this example, you will learn how to create report filters and use them to apply the same criteria on multiple charts, using the following steps:

  1. Open a new Power View report, copy and paste the map from your previous samples into this report, and also do the same for the Bar Chart from the first example of this chapter.
  2. Now, you have a Power View report with two visualization items: Map and Bar Chart.
  3. From the Power View Fields menu, under the Sales Territory Group, drag-and-drop Sales Territory Country into the Filter pane.
  4. You will see a list of countries in the Filter pane. If you choose a country, for example France, you will see only information for that country in the map and bar chart, as shown ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.