Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
Community Champion
Community Champion

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.