{"id":39,"date":"2023-03-28T11:17:23","date_gmt":"2023-03-28T11:17:23","guid":{"rendered":"https:\/\/blog.ivos.place\/?p=39"},"modified":"2023-04-05T16:40:59","modified_gmt":"2023-04-05T16:40:59","slug":"custom-map-visuals","status":"publish","type":"post","link":"https:\/\/blog.ivos.place\/?p=39","title":{"rendered":"(Mis-)use custom map visuals in Power BI"},"content":{"rendered":"\n

Use case<\/h2>\n\n\n\n

In this blog post, I will show you how to use custom map visuals in Power BI to display something different than a region on a world map. <\/p>\n\n\n\n

I first stumbled upon custom map visuals years ago using Reporting Services Mobile Reports. Back then, my boss used to visualize figures on different regions of Switzerland based own region definitions given by the business. <\/p>\n\n\n\n

Based on personal interest, I created a dataset using open data to get the votes of members in the Swiss National Council. I want to display the members on their effective place in the seat plan of the parliament. As I looked at the image of the parliament, I suddenly thought about it as a map. It actually displays a certain object placed on a respective geographical location – even if there is no need for longitude and latitude (in terms of placement on our world map)<\/p>\n\n\n\n

\"\"
Swiss Parliament (Source: https:\/\/www.parlament.ch)<\/figcaption><\/figure>\n\n\n\n

Approach<\/h2>\n\n\n\n

I often try to avoid 3rd party visuals and I check first, if the requirement could be fulfilled with a built-in visual. So I gave the custom map visuals a go!<\/p>\n\n\n\n

\n
\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

First, you need to activate the shape map visuals in the preview features settings in Power BI desktop. It will show up in your visual selection pane afterwards.<\/p>\n\n\n\n

Custom map visuals need a GeoJSON file to display the custom maps. I’d have to generate one using the parliament seating plan.<\/p>\n<\/div>\n<\/div>\n\n\n\n

The seat plan above needs do be represented as GeoJSON file defining the single seats as objects. They also need to have a ID to be able to identify and use them in the report. In this specific example i needed 3rd party tools to convert the seat plan first to a SVG, then to a JSON file (I have used the following converter: Online GIS\/CAD Data Converter | SHP, KML, KMZ, TAB, CSV, … (mygeodata.cloud)<\/a>).<\/p>\n\n\n\n

\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

In the JSON file resulting, an id has to be added to every polygon defined in the JSON file. Those Ids are connected to the respective data in Power BI afterwards. Adjustments like this or other transformations can be done with the online tool mapshaper (mapshaper<\/a>). <\/p>\n<\/div>\n<\/div>\n\n\n\n

\n

Hint<\/p>\nOn one point, I had to rotate the whole JSON file by 180 degrees. I was able to achieve this by using the following command in mapshaper: “mapshaper -affine rotate=180”. Just if you are struggling with this \ud83d\ude09<\/cite><\/blockquote>\n\n\n\n

The Id in your data is now connected to the polygons by using the Id in the “Location” attribute of the custom map visual.<\/p>\n\n\n\n

\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

This was a first trial on (mis-) using custom map visuals not showing “real” geographic data on the world map but allocating areas on a complete different map, like a seating plan. <\/p>\n\n\n\n

Do you have used custom map visuals for other purposes than real world maps as well? Let me know in the comments!<\/p>\n\n\n\n

This is my final report in action, showing vote results based on my seating map:<\/p>\n\n\n\n

\n