Create a Shape Map RF Map in Power BI

Hello! Today let's talk about the "spatial" analysis in Power BI. About the platform for business intelligence, you can read here . I will analyze one aspect in the post - how to draw the RF map in the Shape Map.

In Power BI, spatial analysis can be implemented using the following customizable visual elements:

• Map
• Filled card
• ArcGIS Maps for Power BI
• Shape map

Each has its own advantages and disadvantages, so they are best viewed on the basis of a specific task .

The article will cover the visual element Shape Map . Why didn't we use ArcGIS Maps for Power BI ? Because the administrator has blocked its use!

Taking advantage of the Shape Map was not so easy. The problems are related to the fact that the standard Desktop version of Power BI does not have embedded maps of the Russian Federation.

Figure. Customizable map

Solutions to the problem:

1. Draw the map yourself online. For this, everything is already there . The code of the formed card is displayed on the right. Adding process Own data can be automated by inserting pre-prepared code with the coordinates of objects.
2. Draw a map of the Russian Federation according to the instructions . To implement the required input files = shapefile . Download Shapefile RF by reference .
3. Use the prepared report "Map of the Russian Federation (regions)". Report files can be downloaded from the link (Power BI Report - "Map.pbix", Source table for markup - "file.txt", Map of the Russian Federation in * .json format - "Map of RF.json"). If you need to merge regions into groups (for example), you do not need to redraw the map. It is enough to change the column "desc" in the file "file.txt" so that the regions of the same group have the same value (the name of the group).
   
   

   Regions of the Russian Federation
   
   

   Grouping by region

   
   
   

   useful links
   Editing maps
   Shapefile
   We draw cards
   Files to download