Mislead display on visualization

[Anonymous]

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.

[amitchandak · Accepted solution]

@Anonymous , Check is it a continuous type axis . Make it categorical and check. If needed add +0 to the measure 

[AllisonKennedy]

@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. 

[Anonymous]

@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.