Forum Discussion

PowerVenca's avatar
PowerVenca
Advocate II
10 years ago

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 value...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

 

 

PowerVenca's avatar
PowerVenca
Advocate II
10 years ago

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.