Forum Discussion
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?