Forum Discussion

aghonaim's avatar
aghonaim
Most Valuable Professional
10 years ago
Solved

Wards Map

Is there anyone can help me shape map data based on the wards within the city ?
Show and Tell
  • deldersveld's avatar
    deldersveld
    10 years ago

     

    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.

  • deldersveld's avatar
    deldersveld
    10 years ago

    You can do some additional renaming and column removal, but here are the basic steps in a video.

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

aghonaim

 

Even the Bing map tile in map visual can show districts of a city automatically, but it can only display the geo data field and associated anlytical data field from your dataset. So you must have distrit field (geo data) in your dataset, otherwise you can't group/shape your data on district level.

 

Regards,