Forum Discussion
How to set a minimum/start for X-axis
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.
In your case you could use filters
One way is to drag the measures to the visuals filter and go to advanced filters and choose only show equal or higher etc.
Trivial stuff really
Anonymous Enlighten me and PowerVenca - Exactly how would that change the scaling on the chart?
Trivial Stuff Really?
Totally misred the original question. Didn't mean to come off as arrogant with the "trivial" comment but here goes:
In the case above I've manually excluded all values below the inserted value for this visualization.
Either do:
1) In PowerVencas case; put this value to zero firsty because because negative values seem to be irrelevant to his data visualization and second because BOOM... the gap is gone.
2) this manually and create calculated column with SomeMeasureName = IF((YourNumLine) < 0 , 0 , 'YourNumLine')
lets say negative values are important, 0.1% of the total or more, then ignore this answer :)
With respect and hopefully help
Hi PowerVenca,
I agree with Sean that you need to manually set the start of the x-axis. For your idea about setting a minimum start for X-axis automatically according the lowest number in the dataset, you can post it on the Power BI Idea forum. I will also report the idea internally.
Hello Vicky_Song,
Thanks for suggestion. I will post the idea (hopefully not already posted) on the forum.
