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