Forum Discussion

kevinmathew11's avatar
kevinmathew11
New Member
1 year ago
Solved

undefined

Hi  I'm using filled map in my report and certain districts of a Hong Kong is not picking up filled color values based on the utilization percentage while some districts are not. Any suggestions how...
  • v-kpoloju-msft's avatar
    1 year ago

    Hi kevinmathew11,
    Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to rajendraongole1, for his inputs on this thread. Here I provided some official Microsoft links those might be helpful to resolve your thread more quickly.

    It sounds like you are experiencing an issue with certain Hong Kong districts not displaying colour in the Filled Map visual, even though utilization values are present. This can happen when Power BI is unable to recognize or geocode some of the district names properly especially for smaller administrative regions like those in Hong Kong.

    Here are a few suggestions to help resolve this:

    • Verify that district names are spelled exactly as Bing Maps expects. Consider appending Hong Kong to each district name to help disambiguate the location (e.g., “Sha Tin, Hong Kong”).
    • Set the correct Data Category for your geographic column: Select the column in Power BI. Go to the ribbon → Column tools → Data Category → set it to Place or Address. More info: Data categorization in Power BI Desktop - Power BI | Microsoft Learn
    • Check if the utilization percentage column has blank or missing values for the districts that are not showing. Power BI may skip these if the values are null or zero.
    • If the issue persists, consider creating a column with latitude and longitude coordinates for more accurate mapping. You can then use that in a Filled Map or a regular Map visual. Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn

    Also, please refer to the below mentioned link for more information:
    Create and use filled maps (choropleth maps) in Power BI - Power BI | Microsoft Learn

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Community Forum.