cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SparkDataGuru
Frequent Visitor

Shape Map - Incorrectly Displaying

Recently I downloaded the shapefile for FSA boundaries for Canada found on the Government of Canada's site (https://www12.statcan.gc.ca/census-recensement/2021/geo/sip-pis/boundary-limites/index2021-eng.cfm?y...

After I converted the shapefile to TopoJSON using MapShaper (https://mapshaper.org/) as recommended by the Microsoft's support page (https://learn.microsoft.com/en-us/power-bi/visuals/desktop-shape-map) regarding Shape Map utilization. 

 

Initially I tried using the biggest file, it seemed too detailed to properly load on my Power BI Desktop (actually crashed my program), so I used a simplified file (using MapShaper's simplify tool) and added the file to Power BI again at a much smaller file size. It's now displaying however, the image is glitched/incorrect, with verticies converging to the bottom left corner of the box... anyone have recommendations on how I can properly get Canada's FSA boundaries to properly display? FSA mapshaper fail.png

1 ACCEPTED SOLUTION
Danyel79
New Member

I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.

 

-proj wgs84

 

You can get the topoJSon here

 

Danyel79_0-1675884572813.png

 

View solution in original post

5 REPLIES 5
Danyel79
New Member

I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.

 

-proj wgs84

 

You can get the topoJSon here

 

Danyel79_0-1675884572813.png

 

Thank you Danyel! I tried the file you provided and simplified it. Its displaying properly on Power BI now! 

I do have a question regarding simplifying, I'm not too familiar with mapping tools like these, on MapShaper for simplifcation, which settings boxes did you tick off for 'Simplification' and 'Method' (Douglas-Peucker, Visvalin Effective Area, Visvalingam Weighted Area, etc) , also how much % did you lower it to for Power BI to process it properly? 

I simplified to 20% and it's still quite big. You can probably find a map that's already simplified.

 

Some of this algorithms can be quite complex, you can read more on wikipedia for example.

https://en.wikipedia.org/wiki/Ramer%E2%80%93Douglas%E2%80%93Peucker_algorithm

https://en.wikipedia.org/wiki/Visvalingam%E2%80%93Whyatt_algorithm

 

I got it down to around 5% and it loaded. Appreciate your help!

HotChilli
Super User
Super User

Helpful resources

Announcements
T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors