Bubble size wrong

[Anonymous]

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?

[lbendlin]

which map visual are you using?

[Anonymous]

[lbendlin]

I believe bubble size for these are in pixels.

[Anonymous]

That's what I'd hoped but it is not the case.

If you have the following:

Location, Size

Place A, 1

Place B, 1.4

Place C, 1.7

You get bubbles of radii x, 2x and 3x, which gives areas of y, 4y and 9y. I think it just ranks them.

[lbendlin]

Here is what I see

If you think this needs to be improved please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

[Anonymous]

Thanks for sharing. I'll do that. You have the same problem I do: its obvious that the sizes you've asked for aren't the sizes yoy've got 🙂 

[Anonymous]

Hi Ibendin. Basic map that comes with the service.