0 Kudos

Fill Map USA zipcode limit

Status: New
by trussell Visitor on ‎11-07-2018 08:46 AM

I have a list of every US zip code (about 40,000) and an associated territory name. When I try to use the fill map to show all territories in the legend, it only plots the first territory. However, if I filter the visual and manually select one territory at a time, it's able to plot them on the map correctly. Is there a limit to the number of zip locations that can be displayed at once on the map? Can this please be fixed?

Comments
by Moderator v-qiuyu-msft
on ‎11-07-2018 07:27 PM

Hi @trussell,

 

Would you please share a pbix file with us? If it contains sensitive data, you can upload it to your Onedrive or Dropbox and send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu 

by trussell Visitor
on ‎11-08-2018 07:48 AM
No sensitive data now, its just a list of territory names with every zip code. I changed the distribution and now it does show more than just one, but the same "limit problem" seems to exist because it doesnt show them all. Unless you only filter to see a few at a time. https://1drv.ms/u/s!As61PfH6dsprnXO2BB-ppNKFqbKp
by Moderator v-qiuyu-msft
on ‎11-11-2018 11:45 PM

Hi @trussell,

 

After looking into the report, I find it's due to too many data points to load all data points. You can see there is a warning on the top right of the map, when you click on it, it displays: 

 

q5.PNG

 

q6.PNG

 

You need to filter data until the warning message disappears, or replace the FSS Territory Name field in map visual as US States, then all legends and data points are displaying. See: 

 

q7.PNG

 

For your requirement, you can vote this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7394290-allow-more-data-points-to...

 

Best Regards,
Qiuyun Yu 

Idea Statuses