zipcode heat map with multiple values

[patrickoleary85]

Hi all,

I have two tables - Clients and Staff. Each table has a few thousand rows, but specifically I'm interested in the zip codes. Basically, is there a way for me to display the count of zipcodes for Clients and the count of zipcodes for Applicants on the same map? I'm hoping to use a heat map but can be flexible. The idea is to compare the locations of the two, so we can if an area has a lot of Applicants but very few clients and vice versa.

I tried appending and merging the tables, but I'm not getting what I want. Any ideas? I feel like I'm overlooking something minor, or else maybe it's not feasible to do what I want.

Thank you in advance!

[Anonymous]

Hi @patrickoleary85 ,

If I understand correctly, the issue is that you want to display the count of zipcodes for two tables on the same map. Please try the following methods and check if they can solve your problem:

1.You need to create a relationship between two tables on the zip code column.

2.Using DAX to create a new table that aggregates the counts of Clients and Staff by zip code.

3.Select the map visualization. Drag the zip code field into the Location area. Drag the count field to the size area. Drag the Type field into the Legend area.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format or screenshot to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your reply.

Best Regards,

Wisdom Wu

[patrickoleary85]

Hi,

Thank you for the response! I'm still struggling to gather what I want. Here's a screenshot of the tables and columns that I have to work with. I appended the Applicants and Client lists, but that still creates a separate column for each. 

Perhaps I'm overlooking something here. Any additional guidance you have would be greatly appreciated