Some ideas for how to map data in Power BI Desktop
Part one of a five-part series of blogs

Anyone who has tried to get a meaningful non-US map out of Power BI Desktop will know that it's often not straightforward! This blog shows you how to overcome some of the issues, including geocoding data, getting latitude and longitude settings and changing cross filter settings in relationships.

  1. Techniques for creating maps in Power BI Desktop (this blog)
  2. Starting the map
  3. Geocoding (setting the correct localisation for data)
  4. Obtaining latitude and longitude data
  5. Using latitude and longitude data to create a map

Posted by Andy Brown on 08 June 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Techniques for creating maps in Power BI Desktop

The underlying model for this blog is contained in this file that you can download (I've also included the "answer" file):

Data model

The model contains purchases of animal fluffy toys made from a number of shopping centres in the UK.

Although this is UK specific, the learning points should apply to every country.

The aim of this blog is to - eventually - create the following map:

Sales by animal

The map should show total sales broken down by the four animals for each region.

My hope is that in the process of learning how to produce this you'll also learn about some of the idiosyncrasies of maps in Power BI Desktop!

This blog has 0 threads Add post