Forum Discussion
zipcode heat map with multiple values
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
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