Azure Maps Heat Map Size Field Not Working

[thorpyuk100]

Hi All,

I'm trying to create a heat-map in the Azure Maps visual in PBI Desktop. I have all my points plotted ok on the map, but I want the point size to be dependant on another field. The issue is that whenever I drop that field in, the map goes blank & all the points dissapear.

I've checked the field for errors, and ensured that no datapoints are blank. I've even forced any values > 200 to max out at 200, as it seems to suggest 200 is the largest value for pixel size - no luck.

Please can anyone identify what's happening?

Thanks all!

[Kedar_Pande]

@thorpyuk100 

Ensure that the field you're using for point size is numeric and not treated as text.

Remove other layers or settings that could conflict with the point size field to test if the issue persists.

[thorpyuk100]

Hi Kedar, yes the field is down as 'whole number' and there's no other layers on the map. It's when I toggle the 'use size as weight' option to 'on' that everything vanishes

[Anonymous]

Thanks for the reply from Kedar_Pande , please allow me to provide another insight:

Hi, @thorpyuk100 

You may want to take note of the following:

1.Firstly, you need to modify the data’s Data Category.

For detailed guidance, please refer to:

Data categorization in Power BI Desktop - Power BI | Microsoft Learn

2.Secondly, when entering both Location along with Longitude and Latitude, you should change the aggregation method for Longitude and Latitude to Average.

If you are only using Longitude and Latitude or Location, you will need to disable the aggregation method.

3.Additionally, it is advisable to use Azure Maps on a physical machine rather than a virtual machine, as the drivers in a virtual environment may differ from those on a physical machine. This discrepancy can lead to certain applications being unable to access the necessary hardware resources, given that the graphical processing capabilities of virtual machines are typically limited.

4.Here are my test results:

Currently, I have not encountered any issues in my test cases.

 
Of course, if you have any new ideas, you are welcome to contact us.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[thorpyuk100]

Hi Leroy, i'm using 'Postcode' as my location field, which i've set as 'Postcode' data category.

It works fine for bubble maps, but just not as a heat-map for some reason. I've given up & left it as a bubble-map, but there's clearly a bug that's nothing i'm doing if it's working as a bubble map but not a heat-map using the same field as the size field

[Anonymous]

Hi, @thorpyuk100 
 

Thank you for your prompt reply.

I can certainly appreciate your frustration. However, the good news is that your response has sparked some new ideas for me:

Firstly, you might have overlooked the need to convert the postcode as well.

For further details, please refer to:

Geocoding in Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn

Secondly, considering that Azure Maps may not support certain postcodes, I would recommend using other third-party online tools to convert them into regions or coordinates.

I hope my suggestions bring you some hope.

Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

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