Forum Discussion
How to set a minimum/start for X-axis
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
Hello Anonymous,
Thanks for an answer. I appreciate it (and I don´t take it as arrogant;-)).
The negative numbers are not always shown, but in certain situations they are and it´s important (relevant) in this report (and in other reports I´ve created) that user can see them. So I can´t just "hide" them.
But again, thanks for an answer anyway.