Bubble Chart - Bubbles at the borders

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.