Scatter plot dot size issue

[balabala]

I am working on a small dataset (98) on cars, and would like to do the size map to value of weight. But when I drag the weight to the size, the bubble is very large although I have already set the size to 0%, there is still overlapping from each other. How can I size bubble smaller?

Thank you,

[ShingoMcLeod]

A colleague of mine Dan has found a solution to this as I was having the same problem.  The size property on the visual is your scaling factor, the marker size in the format menu is the start point.  What threw me and others above is that the marker size start point when using scaling is different vs not using scaling.  That makes little sense to me but anyway... the solution here is that you can actually set the marker size (the start point) to a negative amount, up to minus 30 (-30).  That should really help, it did for me 😊.

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

[v-piga-msft]

Hi @balabala,

For your scenario, I'm afraid that you may could adjust the start and end parameters of the X-Axis and Y-Axis to avoid the bubble overlap from each other.

Best  Regards,

Cherry

[balabala]

Thank you for your suggestion. I tried but the result is not satisfied. The bubble is still overlapping, if I start from 0-5000, it will be narrow. if i start 1500-5000, some data will missing. but the bubble's size didn't change. Thank you anyway.

[v-piga-msft]

Hi @balabala,

If it is convenient, could you share your sample data which could reproduce your scenario so that I could copy and have a test.

Best Regards,

Cherry

[balabala]

Sure. Absolutely. I would like to set Weight as x axis, MPG as y axis, color mapping to Manufacturer, size mapping to Weight. And scales not from 0. Below is my sample dataset. Thank you for your help!

Manufacturer	MPG	Weight
ford	17	3449
ford	15	4341
ford		4034
ford		3353
toyota	24	2372
ford	21	2587
bmw	26	2234
ford	10	4615
toyota	25	2228
ford	25	2046
ford	19	3302
ford	14	4154
ford	13	4746
ford	18	3139
toyota	31	1773
toyota	24	2278
ford	21	2226
ford	14	4129
ford	13	4294
ford	22	2395
toyota	23	2506
toyota	27	2100
ford	14	4042
ford	13	4363
ford	18	3021
ford	12	4906
toyota	20	2279
ford	19	2310
toyota	20	2807
ford	21	2875
ford	26	2451
toyota	32	1836
ford	16	4141
ford	14	4638
toyota	31	1649
honda	24	2489
ford	15	3158
ford	14	4657
ford	13	3169
toyota	29	2171
ford	23	2639
toyota	24	2702
ford	18	2984
honda	33	1795
ford	14.5	4215
ford	24	3012
honda	33	1795
ford	18	3574
toyota	28	2155
ford	26.5	2565
toyota	19	2930
mercedes	16.5	3820
ford	13	3870
honda	31.5	2045
ford	18.5	3525
ford	16	4335
toyota	26	2265
ford	25.5	2755
bmw	21.5	2600
ford	36.1	1800
honda	36.1	1800
ford	20.2	2965
ford	25.1	2720
ford	18.1	3205
toyota	27.5	2560
toyota	21.1	2515
honda	29.5	2135
ford	22.3	2890
ford	17.6	3725
ford	15.5	4054
mercedes	25.4	3530
toyota	38.1	1968
ford	26.4	2870
toyota	29.8	2711
toyota	32.2	2265
mercedes	30	3250
honda	44.6	1850
ford	23.6	2905
honda	32.4	2290
toyota	39.1	1755
honda	35.1	1760
toyota	37.7	2050
ford	34.4	2045
ford	29.9	2380
honda	33.7	2210
toyota	32.4	2350
toyota	25.4	2900
ford	20.2	3060
ford	24	2865
honda	36	2205
toyota	34	2245
honda	38	1965
honda	32	1965
ford	22	2835
toyota	32	2665
ford	27	2790
ford	28	2625

[v-piga-msft]

Hi @balabala，

From your first post, it seems that you would like to do the size map to value of weight, but when you drag the weight to the size, the bubble is very large.

By my test, you could set the size like below so that the bubble will be smaller.

More details, you could refer to my attachment.

Hope this can help you!

Best Regards,

Cherry

[balabala]

Thank you so much. Yes, the bubbles become smaller but the problem is it makes bubbles have no evident difference between each other. I think the circle size should be scaling according to the weight. But, thank you anyway.