Canadian County and Postal Code Shading in Power Map for Excel


Good news for Canadian users of Power Map. I discovered by playing with a dataset that it’s now possible to shade polygons in maps at both county and postal code levels! To my knowledge his was not previously possible as only Country and Province shading was available. I was surprised it worked when I mistakenly clicked on the Region Shading option in Power Map!

County Shading

In this demo I’m using Quebec as an example. In the image below you can see the counties (ie Regional County Municipalities) grouped by the administrative region.

Postal Code Shading

For postal codes, the shading is currently available at the FSA level (ie. The first 3 letters of the postal code). However, unfortunately there currently are some missing polygons in the Power Map data for some postal codes. Hopefully this gets fixed soon! Here’s an example showing all the postal codes in the H region.

In a future article, I’ll show how it’s possible to also use Power Map on a custom map of your choosing!

CanadaPowerMap.xlsx

Comments (7)

  1. TW says:

    I tried to do this with Ontario FSA to but doesn’t work (It doesn’t show the regions in colour). I’m guessing it doesn’t work with the preview version.

  2. RandomPerson says:

    Charles, 1. is this function available in the preview version? 2. Were you able to do this for Ontario FSA?

  3. Anonymous says:

    Data sets ThinkData Works Data sets: http://namara.io/#/ The site consolidates data from open.data.ca

  4. vivek says:

    It’s actually a important and useful piece of information. I’m satisfied that you just shared this helpful information with us. –
    http://jobseye.net

  5. carl says:

    Hello, can you let me know your source for the FSA and MRC tabs of your excel file?
    Thanks,
    Carl

  6. Hi Carl. Both are from wikipedia, then transformed with Power Query. You can find the specific transformation step by viewing the Embedded Power Query in the Excel file

Skip to main content