Forum Discussion
How to set a minimum/start for X-axis
Hello,
I was wondering, if there is a some way to set a start of a X-axis according the lowest number or possibility of lowering the minimum.
I have a stacked bar chart showing sum of four values per unit. Three of them are from columns (negative numbers are possible), one is from a calculated measure (which is always positive number).
As you can see at the picture below, one value for unit ED is very small (just half a million), but the minimum value for x-axis is set to 20 millions, so the gap between unit labels and values is too big.
The black vertical line is just a reference line set to 0.
So, how can I lower this "ugly" gap:-)
Thanks for an answer.
10 Replies
You can try this... Select your Visualization and then change the start value of the x-axis
However my experience has been that you can either go to zero hide all negative numbers
Or no matter what number you put in it will not change the chart
Unless it is an increment of 20mil (in your case) - the same increment you have on the positive side
Its kind of annoying because most the time the negatives are so small (you can barely see them) and yet they take a lot of space
Hello Sean,
Thanks for an answer, I appreciate it. I know I can manually set the start of the x-axis, but I meant if there is a way to set it automatically according the lowest number in the dataset (sorry I didn't mention it before).
It doesn't affect the functionality, it just looks bad in certain situations.
But I guess I just have to wait until the PowerBI team solve it or offer some alternative...Thanks again.
