Don't connect dots in line chart if value is null

[Clout]

Hello,

I have a data set which some gaps in it -> value null. Is there a way to dont connect the dots in a line chart when plotted, so its not assuming that data is there?

I would have there a gap in the line chart where the line is crossed:

Thanks in advance!

[EHA_SD]

This is great, but how do you make the categorical axis then fit to the available space within the visual? With a continuous axis it auto-fits, with a categorical axis it does not auto-fit and it adds a horizontal scroll bar instead.

[v-yingjl · Accepted solution]

Hi @Clout ,

Change the type of X-axis to 'Categorical' and enable 'Show items with no data' for the Date field.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Clout , I doubt that in line visual. But try with axis type categorical