Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Lanabanana
Regular Visitor

Scatterchart bubbles cut off work arounds?

5 REPLIES 5
Anonymous
Not applicable

Hi @Lanabanana  Did you ever resolve this?

Hello,

 

I've worked around it defining 2 dynamic measures that sets the maximim and the minimum for Y axis. Let's say that you are plotting <measureA> in y axis. Then you define the following 2 measures:

- MeasureAmax = MAX (<measureA>)*1.2

- MeasureAmin = MIN(<measureA>)*0.8

 

Then, you put these measures in tha max and min options for the chart (where it says fx). This will dynamically change y axis range to your selected dataset.

 

You can do the same with X axis if needed.

 

But it doesn't make any sense to need to define 4 measures for axis scaling because the developpers didn't think about the size of the bubble when defining the auto scale option, it's a bug.

 

I hope ot helps!

I'm still running this issue. But you can't apply min or max on a measure, only a column. Any solution for when measures are plotted and bubbles are getting cut off. 

Yes, need the "Auto" option to include a checkbox for "show entire bubble at extents".

parry2k
Super User
Super User

@Lanabanana great question, and dont think there is any solution for this except you manually change the scale. May be you want to add an idea on ideas forum or vote existing idea (if exists)



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.