Overview
Power BI is a business analysis service offered by Microsoft and comes with an extensive range of data visualization options and business intelligence capabilities. With its simple and intuitive user interface, users of all levels are able to build their own reports and dashboards from one or more datasets.
Currently, there are five different tools for creating map-based data visualizations on Power BI.
Process
There are five standard map visualization options in Power BI Desktop. Click on the bullet points to find out more information about each tool:
 |
|
| |
| |
| |
|
Comparison
The table below brings together the main features, requirements and pros and cons of each map tool. For further information, take a look at the document Summary of the options for map visual in Power BI.
| Basic Map | Filled Map | Shape Map | ArcGIS Maps | Mapbox | |
|---|---|---|---|---|---|
| Visualization type | Simple or sliced points. | Filled polygons. | Filled polygons. | All visualizations supported by ArcGIS Online. | Points, heatmap, cluster map, cloropleth map (for certain locations). |
| Basemap options | Bing | Bing | No basemap. | Anything from the ArcGIS Online collection. | Standard or custom basemaps hosted on Mapbox. |
| Data pre-requisites | GPS points or known location names. | Known location names. | TopoJSON file of the location in question. | Publically available map on ArcGIS Online. | GPS points or known location names. |
| Can be used in any location? | Yes | No | Yes | Yes | Yes (with points) No (with polygons) |
| Main advantage(s) | Easy to use with GPS-tagged data. | Easy to use when dealing with known location names. | Allows using your own TopoJSON file. | Versatile visualization options provided by ArcGIS Online. Many map control options, such as possibility to control the zoom level. | Additional visualizations and possibility to use your own custom basemaps created on Mapbox. |
| Main disadvantage(s) | Supports points only, background maps limited to Bing (not aligned with the UN mapping standards). | Not compatible with the majority of OCHA operations countries. Background maps limited to Bing (not aligned with the UN mapping standards). | Requires preparation of the TopoJSON file and matching the location names, PCodes or other unique identifiers with those in the other datasets. No background map. | Not possible to use in dashboards published or embedded online. No access to private ArcGIS Online content. | Polygon display possible for limited locations only (Global level maps, states of the USA). Limited map control options, such as no possibility to control the zoom level. |
| Ideal use case | When a simple point map is sufficient. | When a simple polygon map is sufficient. | Need to use polygons for a single area. | When sophisticated, multi-layer maps are required and the dashboard will not be published or embedded online for public consumption. | When custom basemaps are necessary. |
Outputs/Resources
- Options for Map Visual in Power BI
- Introduction to ArcGIS Maps for Power BI
- PowerBI Training package with MapBox visual.zip
- OCHA Brand Portal: Creating Online Maps with MapBox and Use Mapbox with custom maps
- MapBox 101 for PowerBI
- OCHA trainings
Guidance
- OCHA_Getting_started_PowerBI.pdf has useful section on page 19 - Mapping - using the Mapbox visual.
- OCHA style guidance for MapBox visual
- Power BI template (A4 landscape and portrait).zip