We focus on BI, Big Data and SQL Server, providing the latest news from Microsoft and the industry, sharing upcoming events, customer stories and SQL Server product information. Find out why SQL and not Oracle or SAP.

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!