Forum Discussion
Problem using custom shape map
Converted shapefile (projection "transverse_mercator") to a Topo JSON file using the website http://mapshaper.org/ but the resulting JSON file has display problems. Here's a screenshot: (1) The left image displays the shapefile in ArcGIS. (2) The top & bottom right are the JSON maps displayed within PBI using different projections.
ScreenCapture
I've even "simplified" the edges of the original shapefile to reduce the number of verticies before converting to JSON.
FYI - The location attributes (from an excel file) are correctly applying to the different areas within PBI.
Any ideas of what I should do? Thank you.
Power BI version: 2.37.4464.361 64-bit (July, 2016)
Windows version: Windows 7 Pro 64-bit (SP1)
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:
25 Replies
Hi ChristianDiscer,
I just tested to import an map.shp file into http://mapshaper.org/ and then export the map into TopoJSON file format. Loading it into Power BI works without any additional configuration from my side, with Power BI the same version as you posted.
So I suspect the issue here should be mostly related with the shapefile you used here. If convenient, would it be available for you to share the .shp file here for us to take a further test?
In addition, take a try to modify the Format section (the paintbrush icon) General part and see if it would help in such situation.
Adding some reference: Shape Maps in Power BI Desktop (Preview).Regards,
Charlie Liao
Thanks v-caliao-msft
Did not see a way to attach a file so use this Dropbox link to grab the file. The shapefile files are in the ZIP along with an Excel spreadsheet to "link" the map area names to: PolTwpPoly.ZIP via dropbox
Also, tried various format settings but no luck.
ChristianDiscer: This ended up being an issue with the original transverse mercator projection. I opened the file in QGIS, converted it to mercator, and exported it back out as a shapefile. From there, it was the same process using mapshaper to convert to topojson.
This file should work: https://www.dropbox.com/s/mx4lig1vmvk4ihw/PolyTestShape.json
