Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)
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?

2 Answers

0 votes
by (22.5k points)
edited by

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.  

0 votes
by (240 points)
reshown by

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


Use that calculation on your chart.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories