Unfortunately, this isn't quite as easy as I expected. I am connecting to a SQL server. I pasted the data to an excel sheet and tried to use that as the source and I can't get the line chart to show the 0s even though it is showing /w the SQL version.
Yet I can't seem to get it to show the 0 values even /w the "Show Missing Values" checked, which isnt check on the SQL version.
OK so I found out the issue, it is because I click "Show Missing Values" on the date for dates that have 0 count. Any work around?
Apologies for delayed response.I haven't been able to recreate a suitable scenario on my end.
Don't know if this will work for your setup, but one possible
workaround is to make a data scaffold with all the dates of
interest and left join to it.
Then you would be able to say
IF NOT(INSULL([Value]) THEN [Value] ELSE 0 END
This should obviate the need for "Show Missing Values".