Skip to main content

Power BI

Needs Votes

Display the real (proportional) size of bubbles

Vote (218) Share
T3chNick's profile image

T3chNick on 22 May 2017 14:43:50

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.

Comments (31)
T3chNick's profile image Profile Picture

0daaa004 79c2-4c2a-b603-0f31334f4dac on 05 Jul 2020 23:54:45

RE: Display the real (proportional) size of bubbles

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.

T3chNick's profile image Profile Picture

55a2c58f f9e1-4530-a604-d33d00f7e820 on 05 Jul 2020 23:54:21

RE: Display the real (proportional) size of bubbles

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

T3chNick's profile image Profile Picture

045d5caf b3ae-4a59-a211-7837b8406bef on 05 Jul 2020 23:53:26

RE: Display the real (proportional) size of bubbles

Yes, agreed.
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

T3chNick's profile image Profile Picture

0e9ddc3b fdb7-45dd-ac75-6b2e4faa6a23 on 05 Jul 2020 23:52:23

RE: Display the real (proportional) size of bubbles

I was surprised to see this is still an issue.

T3chNick's profile image Profile Picture

a5f93f4c 4438-4ea4-994a-d0175430677b on 05 Jul 2020 23:52:17

RE: Display the real (proportional) size of bubbles

This is so basic that can hardly believe it wasn't addressed already!

T3chNick's profile image Profile Picture

dba140fa e610-4285-9782-01aba7450c06 on 05 Jul 2020 23:51:38

RE: Display the real (proportional) size of bubbles

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:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2019-feature-summary/#bubbleSize

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.

T3chNick's profile image Profile Picture

df0c1ff4 ed80-43ae-8e28-8dde2c13a147 on 05 Jul 2020 23:49:27

RE: Display the real (proportional) size of bubbles

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.

T3chNick's profile image Profile Picture

7cda8029 fe72-45c3-a1fc-5092f3079f84 on 05 Jul 2020 23:45:25

RE: Display the real (proportional) size of bubbles

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?

T3chNick's profile image Profile Picture

feca8d48 7221-4f9c-a9b6-ad59fede8239 on 05 Jul 2020 23:02:58

RE: Display the real (proportional) size of bubbles

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

T3chNick's profile image Profile Picture

5a1515ec 1eb2-4597-9322-ea81fd2e3b8d on 05 Jul 2020 22:58:19

RE: Display the real (proportional) size of bubbles

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