Scatter Plot is cut off in Power BI 2019

[Anonymous]

I'm having trouble with this scatter plot in Power BI 2019, as I can't get the axes to includes all of the bubbles in the plot. The problem is that even though the plots axes are set to auto, they only go to the exact point of the biggest datapoint. This leads to them being cut off and I don't know how to get this fixed.

[SamWiseOwl · Accepted solution]

Hi @Anonymous 

If you find the X/Y axis setting you will notice a little fx logo, this is conditional formatting.

You can create a measure that works out your highest value and then adds say 10%.

Right click on your table and choose New Measure.

Max X axis =

MaxX(
AllSelected(Your table)

,Calculate([Your calculation]) * 1.1

)

Hope this helps!

Ps great user name...

[Anonymous]

Hey @SamWiseOwl,

cool username as well 🙂

I'm afraid the feature you've mentioned isn't available in the version I'm using. At least I can't find it in the axis settings for the scatter plot. Maybe I'll try getting a newer version first, if I the IT support will let me.

[SamWiseOwl]

Hi @Anonymous 

Wow I didn't realise 2019 PBI was even still usable!

I would consider publishing your report to your private Power BI workspace (My Workspace) and then try editing it in the browser.

See if the issue persists. You can do this with a free liscence and it will not share the report with anyone.

[Anonymous]

Thank you so much! It works now, I was getting frustrated over this issue.