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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
juniorbasilio
New Member

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?

bubble chart.PNG

 

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.

 

6 REPLIES 6
MFelix
Super User
Super User

Hi @juniorbasilio ,

 

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

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

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
Not applicable

@MFelix 

 

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

 

Best!

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Hi @MFelix 

Thanks once again

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

startend.PNG

 

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

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.