Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to plot values on the standard map using a range of negative values to positive and intending the bubbles to increase in size.
However the map seems to plot the bubbles according to the absolute value. The negatives are given the same size as the corresponding positive values.
Is there a simple solution to this?
Thanks,
S
hi, @Stuartm1983
Based on my research, the size of bubbles is based on the aggregate value of the current city.
For example:
New York is 30, and Washington is -30, but they are not same size of bubble.
Best Regards,
Lin
Hi Lin @v-lili6-msft ,
Coping your example it works. I think it is due to us needing to explicitly change a numeric\character field to an integer or decimal number.
The only issue is that zeros get treated as missing:
i.e. - value v bubble size
15 small
0 missing
30 large
I understand how to work round this (changing 0 to 0.00001) but it seems like a flaw with how the the bubbles operate on the map.
hi, @Stuartm1983
Yes, 0 value won't show on map visual, For your case, I would suggest you create a measure as this
Measure = IF( SUM('Table'[Value])<>0,SUM('Table'[Value]),0.0000001)
Then drag this measure into map visual instead of drag field directly.
Best Regards,
Lin
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |