Forum Discussion
Zip Code Heat Map
I just posted an answer here which should help.
If you get the data in the format:
Company Zip
A 1
B 1
A 2
A 3
I think you can use the heat map to plot zip codes and Count of Company
Helper II'm working on my first PowerBI app and have to do something similar -- I need to show the number of English-Learning students in each zip code area in Jefferson County, Kentucky. I'm using PBi Version 2.1 and haven't found any mapping solutions that shade zip codes with an even "heat signature". Just curious what map you used to accomplish your task?
Helper IAs a follow-up for anybody else looking for a similar solution, I ended up using Shape Map which is already provided in powerBI. It's a preview feature though so you may have to pull it in through the options if it's not already showing in your Visualizations.
- puffster
I Googled and found a site that had the latitude/longitude coordinates of the zips I needed. I was able to download via csv file, then uploaded these into a SQL database that I then imported into PB.
The only other data involved is a second sql table -- no aggregations -- every record counts as "1" and is summed together in the shape file.
For mapping I put the Zip Code field from the Boroughs table into the Location and the # Students from the Enrollment table into Color Saturation. And like magic I had a nice map!!
There is no 'Data category' for zipcode, so what do you set it as? Postal code?
