Display the real (proportional) size of bubbles
Today the bubble size is automatically readjusted and does not allow to have bubbles too large or too small.
I would like to have the option to disable this and have the area of my bubble to be always proportional to the 'size' value.
Brian Van Abbema commented
I have only 15 locations that vary in their values in the 100ks. The bubbles are still all the same size. The visual is useless if it can't show relative differences in values.
This would be very useful! I'm trying to compare sales data and it's very hard to see the difference in location as most of the bubbles are the same size...there's a 350,000 difference in 2 points and there don't look too different in size.
This would be very helpful. Otherwise the visual is very misleading and almost not useful.
However, the 'TreeMap' in Power BI is very good(thanks!) and seems to have found a way
to address the sizing issue.
Leslie Welch commented
Definitely an issue for me, if there is one particularly large size bubble everything else looks relatively the same size even if we are talking about a difference of one being 10% of the other.
Thomas van der Meer commented
I like Power BI a lot, but it is baffling that real bubble sizes are not yet implemented. This is critically broken functionality in my opinion.
David PROVOST commented
We've tried to use some log function in the measure that determines bubble size, tom emphasize small values but the root problem remains : size ratio between biggest and smallest size is approx 3. This should be customizable, like "min size" (points) and "max size" (points) parameters. Instead of this odd slider that ranges from -30 to +30...
Neil Anthony commented
Still an issue on Version: 2.70.5494.761 64-bit (June 2019)
It's concerning, as it can really mislead until you notice what's happening
I was surprised to see this is still an issue.
This is so basic that can hardly believe it wasn't addressed already!
They seem to indicate that a March 2019 update helped to solve this problem, but in reality it just uniformly changes the size of all bubbles:
There should be an option to adjust the level of differential among bubble sizes. In the case of a range with a max of 80,000 and a min of 1, this at maximum differential should essentially render the bubble for a 1 value nearly or entirely invisible on the map and a very large bubble for the 80,000 value. Allowing a user to shift the differential around to find an appropriate balance between size accuracy and visibility to suit their needs would be the ideal solution.
Yes agree. This is a bug in power bi, not a feature request. The bubble map is essentially useless if the bubble size doesn't represent what it's supposed to represent. All we're asking is for the chart to do what it's supposed to do. This is kinda embarrassing for Power BI to have charts that don't do what they're described as doing on a basic level.
I feel like this shouldn't be a request but rather a bug filing. Shouldn't the bubble/scatter chart be displaying values proportionately? I.e., we're not requesting a new feature, we're requesting the visualization control be fixed to work the way it should, no?
I totally agree, the area of each bubble should be proportional to its "size" value!
Otherwise the chart is really misleading as it does not show the real relative size of each item...
We are facing the same issue with the scatter (bubble) chart, which makes it useless in our situation.
Even using artificial numbers is not helping....
Please fix this bug
I think PowerBI is amazing. The first thing that strikes me looking at the map, though, is that when distributing 8000 PC's across a map of the country, the bubble size major metro sites with 500+ PC's is the same size as the very remote sites with 5... it is an inaccurate representation of the data.