topic Re: Map Visualization in Power BI in Developer

Map Visualization in Power BI

karthikaE — Mon, 28 Apr 2025 14:42:09 GMT

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?

Re: Map Visualization in Power BI

lbendlin — Mon, 28 Apr 2025 15:27:28 GMT

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.

Re: Map Visualization in Power BI

karthikaE — Mon, 28 Apr 2025 23:25:34 GMT

Can you suggest an alternative for this?

Re: Map Visualization in Power BI

lbendlin — Mon, 28 Apr 2025 23:38:43 GMT

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

Re: Map Visualization in Power BI

karthikaE — Tue, 29 Apr 2025 08:15:22 GMT

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

Re: Map Visualization in Power BI

lbendlin — Tue, 29 Apr 2025 09:37:50 GMT

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

Re: Map Visualization in Power BI

karthikaE — Tue, 29 Apr 2025 09:51:29 GMT

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

Re: Map Visualization in Power BI

lbendlin — Tue, 29 Apr 2025 10:35:31 GMT

Do you have a suitable topojson file?

Re: Map Visualization in Power BI

karthikaE — Tue, 29 Apr 2025 12:07:38 GMT

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

Re: Map Visualization in Power BI

lbendlin — Tue, 29 Apr 2025 14:01:37 GMT

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.

Re: Map Visualization in Power BI

v-veshwara-msft — Fri, 09 May 2025 10:11:46 GMT

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.

Re: Map Visualization in Power BI

v-veshwara-msft — Wed, 14 May 2025 03:30:22 GMT

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.

Re: Map Visualization in Power BI

v-veshwara-msft — Fri, 23 May 2025 09:58:48 GMT

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.