Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.
-proj wgs84
You can get the topoJSon here.
I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.
-proj wgs84
You can get the topoJSon here.
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!
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |