Forum Discussion
Wards Map
Here's the process I followed for Toronto:
Download the WGS84 version of Toronto's wards from the city's Open Data site. This is a shapefile with a zip extension. Go to mapshaper and import the shapefile and export it to TopoJSON. You can then load the resulting JSON file into Power BI by clicking Add Map under the Shape Map's "Shape" options. Any data that you want to connect should join by keys (click View Map Keys). It looks like you might be able to join based on NAME, LCODE_NAME, or SCODE_NAME.
I've posted a sample PBIX with a Shape Map showing Toronto's wards as well as the TopoJSON file that you can re-use in your own PBIX files here.You can do some additional renaming and column removal, but here are the basic steps in a video.
Excellent! I really appreciate it deldersveld! :)
Sorry to bother you deldersveld once again! Would it be possible to do the same using the new esri ArcGis Map feature ? Toronto wards map is already one of the online Reference Layers there but I don't know how to join/link my data to the wards id/# in the layer! any clue ?
At present, it is not possible to link by the data. The only functionality available now is to select PBI data points by clicking on a reference layer (which I believe simply searching for latitude/longitude points within the bounds of the reference polygon).
OK thanks deldersveld for your reply. I hope this can be done soon. Otherwise I don't see any much value from esri ArcGIS Map than what we used to get from the other Map, Filled Map and Shape Map visuals. Do you see any additional value ?