cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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.

ScreenCaptureScreenCapture

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)

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Re: Problem using custom shape map

I believe that when I converted your file, I lined it up with WGS 84 / EPSG 4326 -- geographic.

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Problem using custom shape map

@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 parametersStep #1: select the shapefile using ArcGIS Project tool & set parameters

 

 Step #2: Parameters selectedStep #2: Parameters selected

 

 Step #3: Use mapshaper.org to convert shapefile to json formatStep #3: Use mapshaper.org to convert shapefile to json format

 

 Step #4: Save as TopoJSONStep #4: Save as TopoJSON

 

 Step #5: Use TopoJSON file in Power BIStep #5: Use TopoJSON file in Power BISmiley Very Happy

 

 

 

View solution in original post

17 REPLIES 17
Highlighted
Microsoft
Microsoft

Re: Problem using custom shape map

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

Highlighted
Advocate I
Advocate I

Re: Problem using custom shape map

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.

Highlighted

Re: Problem using custom shape map

@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

 

PolyTest.PNG

 

 

Highlighted
Advocate I
Advocate I

Re: Problem using custom shape map

@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. Smiley Frustrated

 

Does anyone have an idea? 

Highlighted

Re: Problem using custom shape map

I believe that when I converted your file, I lined it up with WGS 84 / EPSG 4326 -- geographic.

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Problem using custom shape map

@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 parametersStep #1: select the shapefile using ArcGIS Project tool & set parameters

 

 Step #2: Parameters selectedStep #2: Parameters selected

 

 Step #3: Use mapshaper.org to convert shapefile to json formatStep #3: Use mapshaper.org to convert shapefile to json format

 

 Step #4: Save as TopoJSONStep #4: Save as TopoJSON

 

 Step #5: Use TopoJSON file in Power BIStep #5: Use TopoJSON file in Power BISmiley Very Happy

 

 

 

View solution in original post

Highlighted

Re: Problem using custom shape map

@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?

Highlighted
Advocate I
Advocate I

Re: Problem using custom shape map

Yes, by all means use the images in anyway possible.  Thanks again for your help!!

Highlighted

Re: Problem using custom shape map

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors