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:
deldersveld Your file conversion works very well - thank you.
However, I don't know how to properly re-project and/or transform a shapefile from my system for mapshaper.org. ArcGIS contains conversion tools, but I'm not familiar enough to know what settings to use.
Should I use a "Geographic" or "Projected" Coordinate System? Then there are many choices below these two options.
I used mapshaper.org to convert your json to a shapefile hoping to see its geographic information, but ArcGIS shows the coordinate system as "undefined." Which means I don't know what to geographic transformation data settings to use. :smileyfrustrated:
Does anyone have an idea?
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:
ChristianDiscer: Great. I don't have an ArcGIS license, and I used QGIS. If/when I blog this, can I use your screenshots for ArcGIS users alongside my own?
I was able to take Shape Files straight to http://MapShaper.org, import them, and in the Console window, run -proj wgs84 and convert the map to something Power BI would accept.
Hello deldersveld ,
I am trying to display City of Detroit along with Counties in Michigan map. I have downloaded and imported the City of Detroit shape file and Michigan Counties shape file to Mapshaper. I have merged 2 layers using "merge-layers" command in Mapshaper console. I was able to see the City of Detroit boundary under Wayne County of Michigan map in the output of merged file.
I have exported the output in TopoJSON format as a local file. I have converted the output coordinate system to WGS 1984 as suggested in this thread. But, when I loaded this custom map to Shape Map visual in Power BI, I am not able to find the City of Detroit's boundary in Power BI. It is displaying the whole Wayne County with out Detroit polygon.
I have checked Map keys. It is fine. When I filtered City of Detroit in my fields, the Shape Map is approximately zooming in to Detroit's geographic location in default grey color.
I need to display boundary for City of Detroit to appear so that one can select Detroit or rest of Wayne County in Power BI Shape map.
Am I missing some steps to be done in Mapshaper? Can you please help me with this?
I am sharing the source file download links below,
http://gis-michigan.opendata.arcgis.com/datasets/cities-v17a/data?where=NAME%20%3D%20%27Detroit%27
http://gis-michigan.opendata.arcgis.com/datasets/counties-v17a/data
Power BI Desktop Version: 2.84.861.0 64-bit (August 2020)
Windows 10 Enterprise
Thank you,
Abhinav
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.
Aparece assim:
