cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Golani Frequent Visitor
Frequent Visitor

Custom shape map and related data

Hi,

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?

 

thanks !

6 REPLIES 6
Community Support Team
Community Support Team

Re: Custom shape map and related data

Hi @Golani,

 

It will be help for troubleshooting if you share some detail content of your issue.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
deldersveld
Advisor

Re: Custom shape map and related data

How many rows are in your source Excel file and/or how many blocks are being plotted? 

Golani Frequent Visitor
Frequent Visitor

Re: Custom shape map and related data

Hi, i have a topojson with 33k street blocks, and the excel file has 33k rows as well

deldersveld
Advisor

Re: Custom shape map and related data

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."

jonasbakanovas Frequent Visitor
Frequent Visitor

Re: Custom shape map and related data

Can you tell the limit for form maps, I have a map with 1800 rows, and can not display all of them.

Community Support Team
Community Support Team

Re: Custom shape map and related data

Hi @jonasbakanovas,

 

>>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:

How to Use Map Visualizations

Tips and Tricks for Power BI Map visualizations

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |