Map Visualization in Power BI

[karthikaE]

I am trying to build a Shape Map in Power BI that displays territories based on ZIP codes.
Each ZIP code belongs to a Territory ID, and I want the map to show territories using a color gradient based on a numerical column (for example, sales or revenue).
Territories with higher values should appear in darker colors, and territories with lower values should appear in lighter colors.

However, I am encountering an error saying that there are too many ZIP IDs.
I understand this might be a limitation with the number of shapes that Shape Map can process.
Could you please advise how to best handle this situation?
Also, what would be the best approach to optimize the Shape Map for displaying territories using ZIP codes?

[v-veshwara-msft]

Hi @karthikaE ,

We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @karthikaE ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @karthikaE ,
Thanks for using Microsoft Fabric Community.
As we haven't heard from you since last reply, just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[karthikaE]

Can you suggest an alternative for this?

[lbendlin]

I did.  Have fewer data points. For a map visual stay below 5000.  Use filters.

[karthikaE]

Can the shape map be done int area and territory level by aggregating the zip codes?

[lbendlin]

That is one option. Bring your own topojson file with county shapes, for example.

[karthikaE]

Thank you, Do you have the idea on how to achieve this in PowerBI, Sharing this would be more helpful

[lbendlin]

Do you have a suitable topojson file?

[karthikaE]

Yes, I have the topoJSON file. I got this by uploading the us zcta file into mapshaper and simplified it to 10%

[lbendlin · Accepted solution]

Good. Make sure your raw data has a mapping key to the state and county or parish, and that you didn't drop these attributes when you simplified the map in Mapshaper.

[lbendlin]

Every Power BI visual has limits on how many data points it will render. If you exceed that you get the blue "i"  icon in the top right corner indicating that forced sampling is active.

Solution : Have fewer data points. For a map visual stay below 5000.  Use filters.