Forum Discussion
Dynamic X and Y Scatter Plot Axis
Is there a way to add a bit more to the x and/or y axis of a scatter plot so the maximum bubbles don't get cut off on the plot, without manually setting the "End" value?
Not manually setting the "End" value is important because I have a year filter tied to the plot. In 2015 the maximum y value is 23,000 but in 2016 the maximum y value is 210,000. I don't want to set the "End" value to be 220,000 because then the data would look really "squished" in 2015. So I was wondering if I could somehow dynamically make the "End" value Max(Y) * 1.1?
Thanks
3 Replies
Hi handwepg,
Do you mean that you want to dynamically set the Start and End Value of X axis and Y axis for bubble chart?
Actually, the Start and End Value of X axis and Y axis is Auto by default.
So there is no other way for us to set it dynamically, we only could enter the value manually.
You could post your idea in Power BI ideas Forum and add your comments there to improve Power BI and make this feature coming sooner.
If you still need help, feel free to ask.
Best Regards,
Cherry
Sorry I was unclear. I know there is a dynamic "Auto" Start and End. My issue with the "Auto" is that it cuts off part of the bubble the reaches the maximum (see 050 - Shoes in your pasted example).
What I would like is an option that would be something like "Auto + 10% of Max" so the entire bubble would appear on the plot.
Any ideas?
Hi handwepg ,
By my tests and research, I'm afraid that there is no such option like "Auto + 10% of Max" in Power BI currently.
If you want to show the entire bubble, you could set the X or Y axis manually under formatting.
Best Regards,
Cherry
