The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to 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!
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!
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!
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!
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.
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:
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.
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?
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.
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?
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!
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!