Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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:
But when I search in the filters, it suddenly finds a value for that exact area:
What's happening? Is it on some kind of data preview mode where only the first 1000 rows show?
Solved! Go to Solution.
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
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 ?
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