How to use Heat Map properly? Can you use "use size as weight" to make heat map darker or lighter?

[user01]

I think I'm having a fundamental misunderstanding to the "Use size as weight" option when Heat Map is on when using the Azure Map visualization.

I have some dummy data below. For example, let's say I am only interested in looking at employee data on the state level. I turned off labels.

The State column data category is already set to "State or Province". I put State in "Location" and Employee in "Size".

If I turn off the "use size as weight" option, it looks all the heat bubbles are about the same size and about the same darkness. If I turn it on, there is nothing.

If I turn on "3D column layer", the bars look correct.

I want the heat map to be darker where the employee size is larger, and lighter when the employee size is smaller. Below, where the columns are taller, the heat should be darker; where the columns are short, the heat should be lighter. I believe this should happen when you turn on "use size as weight", but it does not.

Is this possible? How do you use "use size as weight" properly?

Below, 3D column is on only for illustration. I want it off in the final result.

Current result: Heat map ON, use size as wieght OFF, 3D column layer ON

Dummy data

State	Employee
Georgia	177
Utah	144
Washington	134
Alaska	132
Mississippi	132
Alabama	129
New York	129
Maryland	125
Kentucky	124
Louisiana	124
Minnesota	123
Illinois	115
Delaware	114
Pennsylvania	110
Vermont	106
California	105
Nevada	104
Maine	101
Hawaii	98
Wisconsin	97
Colorado	93
Massachusetts	93
Florida	91
Oregon	90
Texas	88
Rhode Island	88
West Virginia	77
New Jersey	76
Connecticut	70
Tennessee	69
Virginia	68
Kansas	65
New Hampshire	42
Michigan	38
Idaho	18

Adding:

I forgot to mention that I know an alternate way to kind of do what I want. Use the "Filled Map" visualization, go to "Fill Colors" in Format > Conditional Formatting > Set the gradient based on the Employee column.

But I want to know if it's possible to use Azure Map and how.

Filled Map Viz:

[v-pagayam-msft]

Hi @user01 
Has your issue been resolved after raising a support ticket? If so, kindly share the solution and mark it as accepted to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @user01 ,

Glad that your query has been resolved. 

If this helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @user01 ,

Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as  Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @user01 ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by me. Please let me know if it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.Thank you.

[v-pagayam-msft]

Hi @user01 ,

Thanks for reaching out to the Microsoft Fabric Community Forum about the issue you're experiencing.

Based on the screenshot provided, here are some steps that might help you get the required output:

1. Ensure the field you're using for size is numeric. If it is treated as text, the "use size as weight" option won't work correctly.
2. Turn on the Heat Map toggle and adjust the Radius and Intensity settings to fit your data. The radius controls the size of each data point, and the intensity controls the colour gradient.
3. Switch on the "Use size as weight" option. This should make the heat map darker where the employee size is larger and lighter where it's smaller.
4. Check that there are no other layers or settings that might conflict with the heat map visualization. 

I've attached a screenshot for your reference.

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

[user01]

Thanks, @v-pagayam-msft But it is still not working for me.

1. I set Location =  STATE (Text, State or Province) and Size = EMPLOYEE (Whole number, Uncategorized), OK

2. Adjusted radius and intensity, OK

3. Turn on "Use as weight", NOTHING, everything disappears. I adjust radius and intensity and there is still nothing. I also changed EMPLOYEE summarization to "Don't summarize", but it did not work.

4. I turned off all other layers. I don't know what setting could conflict. I did not adjust any settings. I started over.

Do you have any other ideas?

[v-pagayam-msft]

Hi @user01 ,

Thank you for your response. In the provided HeatMap toggle On screenshot, I have noticed that the radius and intensity settings were not adjusted. If you increase these values, you might see the changes in the visual. For your reference, I have attached the relevant documentation below.

Add a heat map layer to an Azure Maps Power BI visual - Microsoft Azure Maps Power BI visual | Micro...

[user01]

Hi @v-pagayam-msft 

Yes, adjusted those settings. I tried again. I see nothing. STATE column is "State or Province" data category, and Employee column is Whole Number.

It does really matter what values are in the Employee (size value) column, correct? As long as it is numeric?

[v-pagayam-msft · Accepted solution]

Hi @user01  ,
Thank you for your response.
Yes. The field you're using for size should be numeric. If it is treated as text, the "use size as weight" option will not work correctly.

Please go through th above mentioned steps and check step by step again ,if still faces the same issue then please consider raising a support ticket for further assistance.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @user01 ,
Glad that your query has been resolved.If yes, please Accept it as  Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!