Forum Discussion
Plotting negative values on the map visualisation
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 accord...
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, Anonymous
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