Connect to zero value in line chart with multiple dimensions

[Noshyaar]

Hello. I need help displaying line chart that connects to zero values.

The data:

date, person, room
2000-01-01, A, ROOM1
2000-01-01, A, ROOM2
2000-01-01, B, ROOM2
2000-01-03, A, ROOM1
2000-01-03, B, ROOM2
2000-01-03, C, ROOM2

The data is missing a date (2000-01-02), so I use Master Calendar to generate the missing dates.

Line chart I want

• Group dimension: date
• Line dimension: room
• Measure: COUNT(DISTINCT person)

I expected that it would show 2000-01-02 as 0 like this figure:

but as soon as I added Line dimension (room), it no longer connected to that point.

Is there any way I can use Line dimension and have the lines connect to the point at 0 at that date?

Thank you.

[tm_burgers]

In Presentation of the Line chart > Missing Values > Show as Zeroes

and make sure your x-axis property is set to "Continuous"

[Noshyaar]

Thanks for the reply. I tried every 'Missing Values' options (show as gap, show as connection, show as zeroes) but the chart's appearance remained the same. I've confirmed that the x-axis is in Continuous mode.