Forum Discussion

karthikaE's avatar
karthikaE
Frequent Visitor
1 year ago
Solved

Map Visualization in Power BI

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?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

12 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

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

      • karthikaE's avatar
        karthikaE
        Frequent Visitor
        1 year ago

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

         

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    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.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    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's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    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.