Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Custom Shape Map not displaying areas even though they have data

I've built a custom shape map using some public data. I have a unique list of UK MSOA areas, each with a value ranging from 1-5 (labelled as POLAR4); that is one data set. (Probably unrelated, but I can't get it to stop trying to count the POLAR4 column even though the other column is unique and both are set to Text type, and I've set it to Do not summarize).

 

I've then downloaded the shapefile for MSOAs in England and Wales and converted them to TopoJSON using MapShaper, in wgs84 format. I uploaded this and it has made a lovely map. I added MSOA from my other dataset as the Location, and put POLAR4 in both Legend and Color saturation (though it insists on Count of POLAR4 instead).

 

The map looks lovely, except half the values are missing. But, they aren't really missing - if I filter to the MSOA value, it magically finds the data for it.

 

Here is a snapshot of the "blank" data for MSOA E02005794:

PowerBIMap.png

 

But when I search in the filters, it suddenly finds a value for that exact area:

 

PowerBIMap1.png

 

What's happening? Is it on some kind of data preview mode where only the first 1000 rows show?

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

There is a data-point limit in shape maps as far as i remember.  I'll look it up and get back to you.

 

edit : The Shape map visual will plot up to a maximum of 1,500 data points

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks, I'll see if I can get a different visual to do what I'm intending! Don't suppose you have any suggestions @HotChilli ?

HotChilli
Super User
Super User

There is a data-point limit in shape maps as far as i remember.  I'll look it up and get back to you.

 

edit : The Shape map visual will plot up to a maximum of 1,500 data points

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors