Forum Discussion
Mislead display on visualization
Dear friends
i only have data at two point at 1400 and 2000 but i need it to show other value as zero (let line close 0 value on x axis) not joint directly as we see on screenshot below ,
what should i do.
Anonymous , Check is it a continuous type axis . Make it categorical and check. If needed add +0 to the measure
4 Replies
- AllisonKennedy
Community Champion
Anonymous What data are you plotting on this graph? It looks like you have data for other points, as the line is not straight.
One thing you can do is to turn the X-Axis continous to OFF in the formatting for the visual, this will leave a gap in your chart where there is no data.
Other thing you can try is to create a measure, and add +0 or IF(ISBLANK([value]), 0, [value])
to force the line to drop to zero when there is no data.
AllisonKennedy if i turn the X-Axis continous to OFF my visual will look like this, x axis will not be sorted by their value no more
- AllisonKennedy
Sorry, I was writing this from memory. You cannot turn continuous to off - you have to switch it to Categorical.
- amitchandak
Super User
Anonymous , Check is it a continuous type axis . Make it categorical and check. If needed add +0 to the measure
