Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

County-level data not segregating properly in Map visual on Power BI Desktop, but works on Power BI

Hi everyone, I'm facing a strange issue with the Map visual in Power BI Desktop. When I load my dataset and use the Map visual to display county-level data, the data doesn't appear to be properly se...
data protection
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

Thanks for posting in Microsoft Fabric Community and sharing the screenshots. Apologies for the delayed response.

I tried to reproduce the issue using sample data for Alabama (AL) counties and ZIP codes. In Power BI Desktop, if you're only using County or ZIP in the map visual, sometimes the points can appear in wrong places like Europe or South America.

To fix this:

  1. Add a new column like this:

    County_State = [County] & ", " & [State]

  2. Go to the Modeling tab --> Select County_State column --> Set Data Category to Place

  3. In the map visual, use County_State as the Location and your forecast value in the Size field.

  4. If the issue still happens, try clearing the cache: File --> Options --> Data Load --> Clear Cache, then restart Power BI Desktop.

This should help the map show points correctly within Alabama.

Here is the screenshot of the repro:

 

Please find attached .pbix file for reference.

 

Similar discussion: Solved: Re: Filled Map Issues - Microsoft Fabric Community

 

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.


Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,
    Just wanted to check if the solution provided has met your needs. If yes, Please consider marking it as "Accepted Solution" to assist others with similar queries. If further assistance is needed, please reach out.
    Thank you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous  Thanks for response .
      None of this approach work still finding the solution.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous ,

        Thanks for confirming. Since the issue still persists even after trying the above steps, here are a couple of additional suggestions to help narrow it down:

        Could you please confirm whether you're using only County or ZIP in the Location field of the map visual? If so, try removing them and use only the combined County_State column.

         

        Also, just to rule out any cached behavior - after updating the field and setting the data category, try saving the file, closing Power BI Desktop, reopening it, and checking again.

         

        Additionally, based on similar reported cases, you can try creating another column that includes the country for better accuracy:

        County_State_Country = [County] & ", " & [State] & ", United States"
        Then set the data category of this column to Place and use it as the Location in your map visual. This gives Bing Maps more context and often resolves unexpected placements.

        Similar thread: MAP showing wrong locations when using counties - Microsoft Fabric Community

         

        Please refer to this link for Tips regarding Map visuals: Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn

         

        If possible, please share a sample pbix file, or a sample of your dataset (with any sensitive info removed), or a screenshot of the fields used in the map visual. I’ll try to reproduce the exact setup and check further.

         

        Hope this helps. Please reach out for further assistance.

        If this post helps, then please consider to Accept as the solution to help the other members find it more quickly.

        Thank you.