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, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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