Power BI Heat Map Question to group more data

[bv27718n]

Hello! 

I am stuck trying to build a heat map, first question is:

Power BI is telling me too many zip codes to display, is there any way around this or do I need slicers?

2) After pulling in zip codes I want the heat map to display by estimated capacity ranges. There are 15 or so ie, $0-1499, then $1500 to 2499 and so on. How so I set my data up to be able to pull multiple sources like this in?

Thank you!!!! 

[bv27718n]

Good morning! 

Yes and Thank you for your response.

In the ideal world, I would like to see it broken out in the following way but not totally sure what would be beat. Grouped in zip codes by amount (heat map?) of wealth capacity groups. For example Group A would be @500 - $2500 to $4999 Group B  $5000 - 9999 and so on. But I am not clear it it should be done that way or grouped by indivual ID's and then values are the wealth capacities?

In the attached photo is where I am at, in the value on the top of the screen for postal codes it shows 161 to 1.6K. I would imagine that should be wealth capacities? Not sure. 

Another question is sometimes it tells me error, too many zip codes to display. They are zips repeated, how would you account for that?

My ideal thought is for the map to look like this where the darker would be the highest wealth capacity that we could see by city.

[Anonymous]

Hi @bv27718n ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bv27718n]

should I use Azure maps in power BI and do a pie chart of capacties by zip? I tried that but some of the zip codes must be wrong or missing a digit becasue it maps things in Austrailia, Europe etc and not sure how to fix that issue either.