PowerBI allows for the import of a shapefile via JSON to create a map for data visualization.
In PowerBI, I want my users to be able to select either a single country or a region that contains that country.
As far as I can see, my process in QGIS should be:
- Create a shapefile with all country polygons
- Create a shapefile in which I group the country polygons into regions and delete polygons outside the regions
- Merge the two shapefiles
- Convert to JSON
If this process is correct (please tell me if there is a better way!), my problem is that using Merge Selected Features deletes the borders between the countries in the region, resulting in a very politically incorrect map!
Is there a way to group country polygons into a region without deleting borders?