Tableau missing dates with value 0

Question

How can I use a line graph which is having missing dates in our data? I want to give values like 0 for the missing dates. I have created an option, with that I can able to show all the dates in the graph and the missing dates don't have any value. The missing values and not real NULL values, So I want to convert these NULL values into zero. How can I solve this?

Answer 1

Use a calculation field

IF [Dates]=NULL THEN 0 ELSE [Measure] 

Replace this calculation with the original measures 

If you want to learn more about it Tableau, then go through this Tableau Training for more insights.  

Answer 2

Try using ZN. ZN converts a Null measure to 0.

ZN([Measure])

Use that calculation on your chart.