Forum Discussion
Problem using custom shape map
I believe that when I converted your file, I lined it up with WGS 84 / EPSG 4326 -- geographic.
deldersveld Thank you so much, that works great!! Here's are screen captures of the process.
Step #1: select the shapefile using ArcGIS Project tool & set parameters
Step #2: Parameters selected
Step #3: Use mapshaper.org to convert shapefile to json format
Step #4: Save as TopoJSON
Step #5: Use TopoJSON file in Power BI:smileyvery-happy:
I know it's been a few years since this thread was discussed - but I have recently experienced the same issues as (in England) the ONS (government data department) changed their default projection mapping in the 2023 updates - this means PowerBI doesn't, by default, recognise the projection settings. I don't have ArcGIS or QGIS, so was struggling to follow this thread, but I came up with a workaround that's fixed all my issues.
This is only helpful to those who are not expert mappers, or who do not have access to QGIS/ArcGIS/other mapping software.
Background: I was downloading either GeoJSON or Shapefile documents and using MapShaper (www.mapshaper.org), then simplifying and converting to TopoJSON for use in PowerBI. When I used this in PowerBI, I was getting a picasso-esque visualisation that was mad. Basically, PowerBI uses the WGS84 (EPSG:4326) settings to use the custom mapping tool, and my maps had a different co-ordinate system (which I didn't know, or know how to change).
Fix: I used a GeoData converter to identify what the default projection/co-ordinate system settings on my file was (www.mygeodata.cloud/converter/) - in my case, the ONS file was using the OSGB 1936 / British National Grid (EPSG:27700) (that will make sense to some people, but it didn't to me). You can then confidently change the co-ordinate settings for the shapefile/GeoJSON by doing the following:
- Download the GeoJSON/Shapefile.
- Upload the file to www.mapshaper.org
- Simplify as needed
- In a separate tab, use a tool to identify your file's co-ordinate system (www.mygeodata.cloud/conversion) - you're looking for the current EPSG code used by your file.
- Back in MapShaper, go to Consol and type the following: -proj from=EPSG:27700 crs=EPSG:4326
- Change the "from" EPSG code in red to the EPSG code you found in step (4) (in this case it was the 27700 code from the National Grid system referenced above, and I was changing it to the WGS84 system (EPSG: 4326) needed for PowerBI.
- Press enter!
- Export from MapShaper as a TopoJSON
- Voila!
You can then import to the shape map in PowerBI with no problems.
Hope this helps someone else ...
Você pode me ajudar? Já tentei de todas as formas possíveis e não deu certo. O meu continua com o formato do picasso. Posso te enviar o arquivo para ver se consegue entender o que está havendo.