Counting Rows Across Relative Dates, Handling Dates with 0 items?

[pe2950]

I'm trying to generate some reports based off an appointment table.

1 row in the table represents an appointment. The create timestamp of the appointment is linked to a dateKey table.

I have a "count" row in appointment table with the value static at 1; when I'm trying to determine number of appointments scheduled on a given day I just sum all the values of count. 

Now, here is where my problem occurs. I have a column chart where I'd like to display "number of appointments created, by day, for the last 7 days"

In the report, I have DateKey[Date] as the Axis, and Count as the Value. Then the filter is relative to last 7 days. This works out just fine, except for days where 0 appointments were created. Instead of the count of the rows being 0, the visual just sort of skips the date. This becomes a problem if I try to use a line chart, as instead of graphing down to 0 and then back up, it will skip that date and draw a line between the two non zero values. 

Can anyone offer some input on this?

[v-yulgu-msft]

Hi @pe2950,

Firstly, please change the X-axis type from Categorical to Continuous. Secondly, add below measure to chart value instead of dragging the [Count] column into chart.

Measure = SUM(AppointmentTable[Count])+0

Best regards,

Yuliana Gu

[MFelix]

Hi @pe2950,

On the X-Axis option try to change the axis type from Categorical to continuous should give what you need, that is to show the dates without values.

Regards,

MFelix