How to visualise missing dates? #tableautip

I’m going to show you 2 different ways you can show a gap between your missing values in your time series graph. In my example below I wanted to show the gap in time for WWII because the winter Olympics didn’t happen in that time period:

 

 

The first way to show this gap in time for your missing values is to simply change your date field then go to your date header right click and select: ‘show missing values’

 

 

I had to go another route because the winter Olympics happens every 4 years but I didn’t want a line break to mark every moment the winter Olympics didn’t happen I just wanted a break in between my lines for WWII so I created a dummy calculation to force that break for between 1936 – 1948:

IF year([Year])>=1948 then “1”
ELSEIF year([Year])<= 1936 then “2”
END

I then dragged that in details on my marks card and I got my line break for WWII

This was part of my visualisation where I examined female figure skaters BMI which you can explore here

Author:
Soha Elghany
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab