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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.