You don’t have to look at the map data just as columns, you can also use PowerMap to show the data as bubble plots, heat maps, and also as regions by changing the map type.
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
here.
One of the easiest ways to map your Dynamics AX data is through PowerView directly from within Excel. PowerView will automatically recognize geographic columns as mappable data elements, and will translate them to the map view.
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
here.
Everyone has used Pivot Tables within Excel at one point in time to create simple reports against Dynamics AX, and some of you may have also used Power Pivot to create more elaborate dashboards and charts. Recently Microsoft extended out the query and reporting capabilities within Excel with the Power BI suite. In addition to extending the Power Pivot capabilities, they also added three more tools called Power Query, Power View & Power Map, and that means that you have a whole new set of reporting options.
In this presentation we will show you how you can use all of the Power BI tools to analyze your Dynamics AX data.
Perhaps you have heard about the new tool in Excel called PowerPivot, but wonder how it can enhance your use of Excel.
In this series we will show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable.
Extending Dynamics AX 