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
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
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.
You've reached the end of your free preview.
Want to read all 309 pages?
- Summer '17
- Data Management, Power Pivot, Data Model Manager