Forum Discussion
Helper VHow to exactly size a bubble in scatter chart?
Hello,
We have a chart with 4 numerical values where we must explicitly state size and/or color. Works for everything except bubble size:
(1) X-Axis - works fine - can define begin and end value.
(2) Y-Axis - works fine - can define begin and end value.
(3) Legend - works fine - can define colors based on specific values.
(4) Bubble size - DOES NOT WORK - while the bubble does size based on larger, smaller #s - you cannot define exact size - like you can on a line chart where you say 0 is begin value and 10 is end value. If 1 is the lowest and 10 is largest value for a bubble --for a given filter -- then 1 is small and 10 is big. If filter returns 10-20 - then the size of 10 matches prior size 1.
Thoughts on how to resolve this? Have tried various enhanced scatter charts, dot plots, etc - but nothing seems to work. Ideas for a workaround?
Appreciate your assistance.
Thanks,
Dan
Yeah, dancarr22 not sure I see a way around this one. The minute you slice down to a specific value, you lose any kind of min/max reference. I can't see a way around that.
10 Replies
- rajendraongole1
Super User
Please refer this link:
https://community.powerbi.com/t5/Desktop/Controlling-the-bubble-size-in-a-scatter-chart/m-p/169927
Hope it helpful.
dancarr22Thanks rajendraongole1 and Greg_Deckler but those solutions did not work.
The field which the bubble size is based on has 5 potential values: 1-5. That is it. If the dataset contains all 5 values: 1,2,3,4 and 5. Then everything sizes properly. 1 is small, 3 is medium and 5 is big. But, if the user filters the dataset so only 2-3 values appear - say 3 and 4 then the bubbles resize and 3 becomes small - since, due to the filters, that is now the smallest displayed value. But, we do not want that. 3 should be middle/average sized regardless if only 3 is in the dataset of 1-5 or 1-3.
Thanks,
Dan
- Greg_Deckler
Community Champion
Hmm, I am not seeing this in my example. Please see attached PBIX. If I select 3 and 5 from the slicer and then add 1, all the bubbles remain the same sizes. dancarr22
- Greg_Deckler
Sure, put a constant value column in your Size. Then they are all the same? If you are trying to say that a 10 value has a 5 radius and a 1 value has a 1 radius and a 5 value has a 2 radius you can't do that to be best of my knowledge. What are you trying to achieve?
