Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Bubble size wrong

I have some data like this:

 

location, radius

Place A, 1

Place B, 1.41

Place C, 1.73

 

I am trying to plot it on a basic map.

 

The radii are carefully chosen so that the area of each bubble indicates the number of times the place appears in the underlying data. 1.7 is SQRT(3), so a bubble with radius 1.7 will have 3x the area of a bubble of radius 1.0, indicating three events at this location.

 

However, when Power BI plots the bubbles, I get bubbles with radii of 1, 2 and 3, which gives areas of 1, 4 and 9! I have no idea why Power BI is doing this, but it *seems* to be ranking the size column in my data, then deciding for itself to make each ranked row one whole unit more in radius than the previous ranked row. Is there a way to stop it from doing this and force it to treat my data as the desired radius, or pixel count, or something?

 

 

 

 

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Ibendin. Basic map that comes with the service.

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      • lbendlin's avatar
        lbendlin
        Super User

        I believe bubble size for these are in pixels.