Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 in the following screenshot:

  5. Also, you can highlight a specific part of data in any of the charts (for example, Road Bikes in the bar chart), and you will see that the other chart also highlights information for that category. Check the preceding screenshot...