Heat Map Color Coding

[adamjon92]

Good morning,

I have a heat map where I'm trying to show the locations where we are over 100% capacity (red), 85%+ capacity (yellow), and <85% capacity (green). I have the parameters set but there are quite a few locations that aren't showing as red where they should be. For example, Denver, Dallas, and Los Angeles should all be red and most of the other cities should be yellow but they're showing as primarily green. Am I marking the parameters incorrectly? Also, is there a way to have a circle be solid green rather than have yellow in the middle? Chicago is only 78% so it should be solid green. I changed the percentages so they were whole numbers, which is why there aren't decimals in the parameters. Thank you! 

[johncolley · Accepted solution]

Hi @adamjon92 , I don't think the heat map colouring works the way you are intending. I suggest using conditional formatting to colour bubbles on a map chart. In my example below I've added the city and capacity columns to the location field and then created a rule based on the capacity.

If this answer solves your problem please mark it as a solution!

[adamjon92]

Thank you very much! This worked. Have a great weekend!