Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 |
|---|---|
| 50 | |
| 41 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 72 | |
| 37 | |
| 27 | |
| 24 |