Although the PowerView map functions are nice, PowerMap is a much better way to visualize information geographically.
NOTE: This is part of the Using PowerBI to Analyze Dynamics AX Data blueprint series where we show how to use PowerView, PowerPivot & Power Map to analyze and visualize your data more effectively. If you want to see all of the other posts in this series, click
How to do it…
To use PowerMap to visualize the geographic data, follow these steps:
- Select the filtered query that you built in the last section, and then click on the Map option within the PowerMap group of the Insert ribbon bar. Then select the Launch PowerMap option to open up PowerMap.
- When the PowerMap Editor is displayed, it should have already scanned your columns and then associated them with the different geography levels – i.e. City, State, Zip Code etc.
- You can change the mapping level by changing the selection in the Geography and Map Level panel on the right of the view.
- When you have done that, click the Next button to start editing your map visualization.
- If you drag the Location ID (or any of the measurable elements in the query) into the Height field on the designer on the right, then your data will start reflecting the impact of the variable.