Bubble Chart - Bubbles at the borders

[Anonymous]

Hi Guys,

I tried searching for this but found nothing. If this was already solved, forgive me.

To the point:

I created a series of bubble charts to track performance for some products.

The issues I had are listed below:

1. I needed to create a two axis chart + 1 volume dimension. This was fine, but I had the problem that if one of the axis had no value (or value = 0), the bubbles were not being presented. As I was using measures in both axis, I changed the formula to replace 0 to 0.0000001. This solved the problem. Later on, I found that there's a option to show the 0 values, so I think I'm fine with it.

2. The charts are complete and they are exactly what I want. However, some bubbles are shown at the very ends of the charts (at the borders). This is quite annoying and I don't want to change the scales manually. If it was for me, not a great deal, but to truly present it I need that the bubble are completely within the chart (please see image attached to visualize what I'm talking about).

Is there any way to solve this?

3. Last but not least, I wanted to plot on the charts the average line. Luckly it's possible. The sad side is that It just plots a simple average, and not a weighted average, which is quite disppointing considering that it seems a very useful option. Just to note, for this problem I found a topic, and at that time there were no solutions. Do you guys know if by now we've a solution?

Thanks.

[MFelix]

Hi @Anonymous ,

Did you try to change the axis scale type from linear to log?

Regards,

MFelix

[Anonymous]

Hi @MFelix 
Unfortunately, there's no option to visualize the axis in a log scale (at least with this data set). =/

(for some reason I had to create another username to log in into the forum, that's why it's different now).

I know that I can change the start/end of the chart for each axis, but It's not a solution when I want to change it dynamically with other visuals. =x

Thanks for your reply!

[Anonymous]

@MFelix 

Just to update, I think this image shows better the problem I'm having: https://ibb.co/tbb8HRz

Best!

[MFelix]

Hi @Anonymous ,

The scatter chart in PBI doesn't allow this customization of the max and minimum values, did you try a custom visual?

Check this post maybe it gives you a good option for your needs.

Regards.

MFelix

[Anonymous]

Hi @MFelix 

Thanks once again

If I'm not missing something, I can actually change the start/end for the axis (see below)

Unfortunately, It's a fixed solution so when I change the data perhaps that start/end point would not be the best.

Anyway, I've been through the post u sent but didn't try the impact bubble chart - will give it a chance.

Would be really great if Power BI identified it's not showing the whole bubble within the chart - perhaps we see it solved in the near future.

Best,

Junior

[MFelix]

You can check in the ideas part of the forum if someone alredy posted a similar need.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/search?filter=hot&oauth_consumer_key=plilavrI...

Regards,

MFelix