I am trying to display population per block in NY city with color saturation. I have a shape file (topojson) in which each bloc has a unique GEOID value.
I also have an Excel file with 2 columns GEOID and POPULATION (the topojson also bears the population value)
I am not sure about the best to do so, what i currently do is the following:
1) Load the Excel file
2) go to shape map and load the topojson
3) put the Excel GEOID in the 'location' bucket and the Excel POPULATION in the 'color saturation' bucket
For some reasons only 1/3 of the blocks on map are colored and show the population in the tooltip and i dont understand why.
I made sure geoid are both of the same format.
Am i doing something wrong?
It will be help for troubleshooting if you share some detail content of your issue.
33k is too much for the visual to support. You might see an "i"/info icon in the top left corner that displays the message when you hover: "Too many values. Not showing all data."
>>Can you tell the limit for form maps, I have a map with 1800 rows, and can not display all of them.
It sounds like shape map can't fully analysis your data, please ensure you have correct setting the data categories and haven't use two-letter abbreviations.
For more detailed information about how to use map visual, you can refer to below links: