Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am trying to build a heat map on PBI Desktop.
The location field of the map is calculated column as follows :
Solved! Go to Solution.
Hi, @GallopPBI
Make sure that the categories and fields are correctly categorized in Power BI Desktop. This helps Bing Maps interpret and geocode the data correctly. You can set a data category by selecting a column in the Data view, and then under the Column Tools tab, you can set the Data Category to the appropriate type (for example, Zip Code, City, Address). For more information about data classification, you can check the link:
Data categorization in Power BI Desktop - Power BI | Microsoft Learn
If possible, add latitude and longitude data to the dataset. This approach eliminates ambiguity in location data, resulting in more accurate mapping. You can then drag these fields into the latitude and longitude buckets in the map visualization settings. This method eliminates the need for Bing to geocode location data, allowing for more accurate clustering and positioning on the map.
If the built-in map visuals in Power BI Desktop don't meet your needs, consider exploring custom visuals from the Power BI Visuals Marketplace, or using Azure Maps visuals for Power BI, which may provide more flexibility and accuracy for specific use cases. Azure Maps visuals allow for detailed customization and potentially more control over how data is displayed and clustered. For more insights on improving map visuals in Power BI, you can review the following documentation:
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yohua-msft I think the problem is like this...when I select a value from the dropdown and refresh the page link I see the map with multiple bubbles. When I then click the reset green arrow on the dashboard the view becomes fine and shows the clustering. Can you please advise?
Thanks
Hi, @GallopPBI
Make sure that the categories and fields are correctly categorized in Power BI Desktop. This helps Bing Maps interpret and geocode the data correctly. You can set a data category by selecting a column in the Data view, and then under the Column Tools tab, you can set the Data Category to the appropriate type (for example, Zip Code, City, Address). For more information about data classification, you can check the link:
Data categorization in Power BI Desktop - Power BI | Microsoft Learn
If possible, add latitude and longitude data to the dataset. This approach eliminates ambiguity in location data, resulting in more accurate mapping. You can then drag these fields into the latitude and longitude buckets in the map visualization settings. This method eliminates the need for Bing to geocode location data, allowing for more accurate clustering and positioning on the map.
If the built-in map visuals in Power BI Desktop don't meet your needs, consider exploring custom visuals from the Power BI Visuals Marketplace, or using Azure Maps visuals for Power BI, which may provide more flexibility and accuracy for specific use cases. Azure Maps visuals allow for detailed customization and potentially more control over how data is displayed and clustered. For more insights on improving map visuals in Power BI, you can review the following documentation:
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
esri Map Clustering theme doesnot work correctly. ... - Microsoft Fabric Community - Seems similar problem. Can you please guide here @srikanthgr1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
87 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |