cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mandy22 Frequent Visitor
Frequent Visitor

Zip Code Heat Map

I have a table Companies that contains the fields company_name and zip_codes. zip_codes contains all the zip codes that they provide service in, separated by commas. Some companies have 300 zip codes.

 

I want to be able to display a map that shows the areas those companies provide service in, and have it shaded by the amount of companies serving in that area, heat map-style.

 

Example: Company A services zip codes 1, 2, 3, 4, 5. Company B services zip codes 3, 4, 5, 6, 7. The map should have color in zip codes 1-7, with 3-5 being darker than 1, 2, 6, and 7. 

 

I've tried doing this with the heat map feature on the bubble map visual, but in order to do this, I have to first separate all the zip codes into separate columns, giving me 300+ columns of zip codes. Going through each one and transforming them into Data Category Postal Code with Don't Summarize is slow and painful, and dragging each of them to Location takes 2 minutes to load each time. 

 

I've also tried using ArcGIS, but it doesn't recognize multiple zip codes in a value. 

 

Is there any other way to do this, or do I just have to buckle down and do it the first way that I tried?

1 ACCEPTED SOLUTION

Accepted Solutions
HotChilli New Contributor
New Contributor

Re: Zip Code Heat Map

I just posted an answer here which should help.

https://community.powerbi.com/t5/Desktop/Parsing-comma-separated-values-for-slicer/m-p/780445#M37590...

 

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

View solution in original post

1 REPLY 1
HotChilli New Contributor
New Contributor

Re: Zip Code Heat Map

I just posted an answer here which should help.

https://community.powerbi.com/t5/Desktop/Parsing-comma-separated-values-for-slicer/m-p/780445#M37590...

 

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

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)