Create a table using the customer FullName and customer StateProvince Switch

Create a table using the customer fullname and

This preview shows page 197 - 200 out of 309 pages.

Create a table using the customer FullName and customer StateProvince. Switch the table to a map and drag the Full Name field from the Color drop box to the Size drop box and change the aggregation to Distinct Count. 14. Drag the HouseOwnerFlag to the Color drop box. Zoom in to the western United States; your map should look similar to Figure 9-33 . Figure 9-32. Using a scatter chart with a play axis to determine the greatest profit
Image of page 197
CHAPTER 9 CREATING STANDARD VISUALIZATIONS WITH POWER VIEW 198 15. Experiment with mapping other fields and zooming to different areas of the map. When done, save your changes and exit Excel. Summary In this chapter you have seen how to create the various visualizations in Power View. You created the standard column, bar, and pie charts. You looked at line and scatter charts and how you create bubble charts and add a play axis to look at trends over time. In addition, you saw how to present measures tied to a geospatial field on a map. At this point, you should be comfortable creating the various visualizations in Power View. Up to this point, you have created each of the visualizations as a standalone chart or graph. One of the strengths of Power View is its ability to tie these visualizations together to create interactive dashboards. You will explore this in the next chapter. Figure 9-33. Mapping the number of customers
Image of page 198
199 CHAPTER 10 Creating Interactive Dashboards with Power View In the last chapter, you investigated some of the standard visualizations used to create reports and dashboards. In this chapter, you will combine these visualizations so they work together to form interactive dashboards. Interactive dashboards differ from a traditional dashboard by extending the user experience from passive to active. You can perform filtering, drill up or down through different levels of detail, and discover associations between the various metrics. You will also look at how you can group the data using tiles and create filters for the groups and views as a whole. In addition, you will look at how you can include images to enhance the dashboard experience. After completing this chapter you will be able to Link visualizations in Power View. •± Use tiles to organize data. •± Filter groups and views. •± Expose dashboards to consumers. •± Note For copies of color figures, go to Source Code/Downloads at . Linking Visualizations in Power View One of the strengths of Power View is that if the Power Pivot model contains a link between the data used to create the various visualizations, Power View will use the relationship to implement interactive filtering. Interactive filtering is when the process of filtering one visualization automatically filters a related visualization. For example, Figure 10-1 shows a bar chart that displays sales for the different product categories from the Adventure Works sample database.
Image of page 199
Image of page 200

You've reached the end of your free preview.

Want to read all 309 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes