Power View Map RRS feed

  • Question

  • Hi Experts,

    I want to create a map that shows the Ship route based on Latitude and Longitude,

    Is any one having idea ?


    Wednesday, November 2, 2016 9:25 AM

All replies

  • Hi UrsAnandh,

    Maps in Power View display your data in the context of geography. It uses Bing map tiles, so you can zoom and pan as you would with any other Bing map. To make maps work, Power View has to send the data to Bing through a secured web connection for geocoding, so it asks you to enable content. Please refer to the follow steps to create a power view map.

    1. Login to the SharePoint site as an administrator.
    2. Navigate to your PowerPivot Gallery.
    3. Choose a workbook which you are going to use as a source for your Power View Map. Then you will create a power view map in Excel.
    4. Click the Create Power View Report button in the top right corner of the workbook. Drag a geographic field such as Country/Region, State/Province, or City to the Power View sheet or view to create a table. Drag a numeric field such as Sales to the table.
    5. On the Design tab, click Map, which displays a dot for each value, and the size of the dot represents the value.  Enter the title and edit the map according to your needs.

    For more details, please review the article.

    In addition, Power View is a standalone component of Excel 2013, no longer requiring a SharePoint Server.  It is now possible to quickly and easily create fully interactive, zoomable maps of the world, while showing your own data on them. Best of all, it is not even necessary to store longitude and latitude information in your data. As long as you have a textual name of a city, country, or region, Power View is able to automatically geocode your data so it appears in the right place on the map.

    Best Regards,

    Thursday, November 3, 2016 10:36 AM