Azure Maps

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) …

In the example we will use for the demonstration, we generated 100,000 transactions that record the sale of items (alcoholic and non-alcoholic beverages) in 10 retail outlets whose exact location we want to see on the maps. I chose MAXI supermarkets because this situation reminded me of the days when my wife and I, out of sheer boredom, decided to collect stickers for the album “Animal Kingdom”. Since there was a different batch of chocolates in each supermarket (one picture comes with each “Animal Kingdom” chocolate), we visited them all in order to have as few duplicates as possible. A great excuse if you like to eat chocolate, just be careful not to end up in the Emergency Center because of the high blood pressure that is a consequence of this hobby!

When import data into Power BI Desktop and link tables, you need to choose a visual called Azure Maps. It has recently been available as a trial functionality, so if you don’t see it in the palette, try adding it from the Power BI Desktop options menu. You will recognize it in the palette by resembling an arrow – a stylized letter A. When you put it to the canvas first in the Longitude field you need to drag the dimension that represents longitude, and in the Latitude field, the one that represents latitude. The Size field indicates the size, here e.g. you need to add the sum of quantities or amounts sold. If you want to have a better insight into the details in the Legend field drag the dimension that additionally describes the sales, it can be e.g. item classification.

It is possible to change the perspective of the map, and there are a number of additional options in the visual formatting menu. Next, you can choose a different map style or turn on the current traffic view on the map. You can also choose whether to use the Bubble or Column chart to display the data. You can rotate and zoom the map until you get the view you want!