How to have a gap in a line chart where there are null values

[daircom]

Hi all,

I have a graph based on data which has null values. However, I need the graph to simply show a gap where there are null values, instead of interpolating the graph by a straight line. 

The solution I come accross on this forum requires to turn the x-axis from continious to categorical. This solution does not work for me as the x axis has hourly data and when set to categorical it becomes unreadable. 

To summarize: how to show a gap in my line graph where there are null values without setting the x-axis from continious to categorical?

I don't want:

I want it to look like (done with paint):

[lbendlin · Accepted solution]

You could use a categorical axis type but that would lose the auto hierarchy.

[Anonymous · Accepted solution]

Hi,

Thanks for the solutions bendlin  and SamWiseOwl  offered, and i want to offer some more information for user to refer to.

hello @daircom , if you want to implement the null value without lines, you need to change the the x-axis from continious to categorical, and you said the that your x-axis is date/time, you can add a new colunn in table to just extract the date from the date/time field.

Column = DATEVALUE([Date])

Then put the new column to axis, and set it to categorical, and clixk the x-axis, and select 'show item with no data' it can work.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

You could use a categorical axis type but that would lose the auto hierarchy.

[SamWiseOwl]

Hi @daircom 

If the problem was at a higher level like Year and Month you can use a calendar table.

This won't show items with no data at first.

By forcing it show items with no data you for the gaps