Select Page

Excel Video 504 Power View Maps Part 2

Apr 18, 2016Business Intelligence

Now that we have covered the basics of creating Power View Maps, Excel Video 504 adds several more features you might find helpful. Watch how adding a field to the Colors area turns the bubble points on the map into pie charts. Now you can see the number of patients based on the size of the bubble and the clinics those patients visit based on the pie chart inside the bubble. As you would expect, vertical multiples, horizontal multiples, and tiles work as they do in other visualizations. Adding geographic fields to those areas can give you even more insight as you analyze the Power View Maps.

We will also add another geographic field to the Locations area. Now I can drill up and down inside the map to larger and smaller geographic areas. You could start at a state level and drill down to county, city, and zip code if you have the geographic data. Drilling back up through those same levels is just a click away.

The next topic for Excel Videos is 3D Maps, a new feature in Excel 2016. Those maps have different features and flexibility than Power View, but if you want to combine maps with other Power View visualizations, here are several tips to get you started.