Azure Map Heat Map "Use size as Weight" not Working

[jwong5]

I have difficulty getting the heat map in Azure map as I wanted. This is the current setting of my visualization. Zip State as the location, and Volume, which is a calculated measure as size. Zip State is assigned data category of place. Volume is set to be whole number (with large range).

I have 3 color settings in Heat Map.

I would like the colors to be based on the value of the volume. For area with largest volume, it shows red, with median volume, it shows yellow, and the lowest are would show with green color. In the current Heat Map, I turned on the "Use size as weight" option, hoping this would achieve to the goal, but it did not. The color all show up the same, dark red. I wonder if anyone can share the working experiences. Thank you! 

[jwong5]

Thank you @amitchandak ! I was not referring to bubble map, but the heat map in Azure map. The size of the dots in heat map does not correspond to the measure value. It could be that I used zip in the reference table as location, and the map treats every value the same even though I added measure to the chart. 

[v-achippa]

Hi @jwong5,

Thank you for the response, here the issue is likely because of location accuracy. Since you are using ZIP and State field as the location, the map may be resolving all points to the same or very close coordinates, that is why it looks like a single intense hot spot. Please follow below steps:

• Use separate Latitude and Longitude columns instead of a text based ZIP or ZIP State field. And add those to the Latitude/Longitude fields in the visual.
• Add your measure to the Size field and turn on Use size as weight.

Once this is done the heat map will show the correct gradient and intensity based on the measure values.

If this post helps in resolving the issue, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[jwong5 · Accepted solution]

Hello!

The solution did not work 😞 I decided to use the filled map option in Azure map and color coded areas by different volume and it worked.  Thank you for your f/u!

[v-achippa]

Hi @jwong5,

Thank you for the response and confirming that the issue is resolved now using the Filled Map with color coded areas and it worked well. I request you to please mark the post as Accept as Solution so that other community members who has similar issue will find it more easily.

Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jwong5,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jwong5,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @amitchandak for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and give a kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[amitchandak]

@jwong5 , in the Bubble color, I am able to use conditional formatting, I can use gradient or field value based on need