The introduction of the SVG format in Excel has gone unnoticed by most users, and it enables the conversion of maps into standard graphics objects. After that, you can do whatever you want with them. In this simple “recipe”, I’ll show you how to convert and format SVG maps you have previously downloaded, in order to create effective reports…
Azure Maps is a new Power BI visual that enables the display of data on geospatial maps with greater accuracy of display, and as such are suitable for the development of Internet and mobile applications, as well as specific reports in which the exact location of the object is important. These maps are a much better choice when you have the exact location of the object you want to show on the map (latitude, longitude) …
Excel 2019 has got a new type of maps that we can use to illustrate the data from the spreadsheets we’ve made. Actually, this is just another chart that we can add from Insert ribbon or after launching the Recommended Charts option. It allows us to create filled maps, where each country from the given dataset is filled by a color according to given values.
Vector maps were always better than raster for better quality and more precise location display. Power BI since recently supports ArcGIS maps, based on Esri’s geographic information system, which in addition to common functionality of maps offers the ability to use some profound options and display statistics. The text that follows will be about the basic features of this visual.
Most of us are using Google Maps, but a few years ago Microsoft also went into the race and created its own version of the maps named after its Bing search engine. From Excel 2016 exists an add-in with the same name that you can use to display charts on maps. It allows you to display data, in a form of charts, positioned on maps that can be customized to the desired report layout.