Map bubbles are in same size irrespective of the values

[Anonymous]

Hi 

I have a location and sales revenue column. I plotted a map and it's working fine. However, the bubbles are the same size. My revenue has different values. 

I need to show some change in bubble size as a user can get an idea. Is there any way?

[Anonymous]

@Anonymous 
Map visual works fine in my test, make sure you are using the latest desktop version. And what is that formula for the revenue measure?

Paul Zheng _ Community Support Team

[Anonymous]

@KNP Hi I am using MAP Visual

[KNP]

I assume you have your measure/value in the 'Size' field?

If it is a value not measure, is the aggregation set correctly?

[KNP]

Unless the aggregation is set incorrectly the size usually just works.

[Anonymous]

@KNP 

Yes my revenue is a DAX measur and in the size 

That means it's not aggregating? How to rectify it?

[KNP]

The measure should just work.

If you hover over the circles, do the values display correctly? (I suspect they do)

If so, my suggestion would be to use one of the other map visuals that provide more options for sizing. 

[Anonymous]

@KNP Which other map we can use? I don't see any other map with bubble for the sizes. please advise. 

[KNP · Accepted solution]

Sorry @Anonymous - I missed this message.

Azure Map is the one that gives more control over the bubbles.

[Msong4u]

The Map Visual is very tricky and I have learned a but about it today.

First of all, if all bubbles are the same size try this  

1.  First of all, for some reason, the map settings overall can be turned off.  So you have to go to File > Options and Settings >Options > Security > and check the Use Map and Filled Map visuals box.   
2. On the far left click on the Tables Icon which is under the Visuals icon.
3. Click on the numerical value that you want to see in different size bubbles.
4. Inspect settings: Check to see if the Data Type is a Whole Number and if Summarization is set to Sum.  If it is, you should see a Sum Symbol next to the field.  In my case it was annual sales.
5. This is a good area to review as well.  Play around a little. 
6. Now, if the relative sizes are off - go to the visualization column on the right and click from the add data field to the the Format your visual field which has a paintbrush on it. 
7. Click on Buttons and play with the Range Scaling settings.  Sometimes, the options are grayed out so you have to isolate when of your numerical values.  Data Range and Magnitude seem to change the size of the bubbles more than Auto setting.

[Msong4u]

If I may offer a suggestion.

When you answer a question, provide step by step instructions.  

1. I am having this problem now and it happens over and over again.
2. No one seems to know why.
3. And then  I get here and I see a menu screen screenshot. 
4. How do I get to that menu screen?
5. How do I find the Azure Map Visual?

[KNP]

And if I hadn't had an entire conversation with the OP leading up to my marked solution I would totally agree with you. I could already see that offering them another visual option based on the conversation was enough.

I'm not sure there's a lot of benefit to posting comments on a post from 2021.

[KNP]

Hi @Anonymous - Which map visual are you using?