Forum Discussion
Correcting negative values in the graph?
I have a graph showing indicator values that are in the billions home and when I came up some value less than 1 billion the value is negative, changed the type of data to thousands had improved but some values still appear negative, I believe it is something simple to fix but I'm not finding the option for it
Anonymous What is the column that displays the negative number? Is that a measure? There is obviously something that is converting your numeric values to a negative...
You can filter the data out, but I'd look at why it is converting all positive numbers to a negative rather than removing something from your dataset. I can't read the language, so I don't know what to specifically detail.
Anonymous I agree with you
And I kind of tried to tell him the same thing - but he brushed it off - so I just showed him how to hide it
That negative data that shows up - it doesn't just appear out of thin air
I would look into it but he claims there's no negative data so I just left it at that...
7 Replies
If you want to hide the negative values - use a Filter.
But it looks like (and I have no idea what I'm looking at) but it looks like you have Negative Values in the data you aggregate
So I don't know what you mean correct the negative? Unless you go and change the numbers in your data source...
Anonymous What is the column that displays the negative number? Is that a measure? There is obviously something that is converting your numeric values to a negative...
You can filter the data out, but I'd look at why it is converting all positive numbers to a negative rather than removing something from your dataset. I can't read the language, so I don't know what to specifically detail.
I have the same problem. I tried to filter the results, but don't work. I don't have negative numbers in my table.
I used ABS to change negative to positive number.Also, the filter show the negative numbers.
The table came from .CSV
