Creating Dashboards with Power View - Microsoft Business Intelligence Tools for Excel Analysts - page 98

Figure 5-13: Excel generates an initial Bing map.
The initial map is often fairly useless. How Excel decides to initially handle your data varies from data-
set to dataset. As you can see in Figure 5-13, Excel gives you a warning there are too many zip codes
to plot on the map. In this case, we'll need to make some adjustments to get the view you need.
Move your location field to different drop zones in the field list. Figure 5-14 shows how moving
the Gen_Zip field to the LOCATIONS drop zone fixes the map and creates a nice view of the data by
zip code.
Figure 5-14: Moving the Gen_Zip field to the LOCATIONS drop zone creates a nice view by zip code.