Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 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

 

Need Help
Show and Tell

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi, Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        6 years ago

        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