Hey there. I have a Date field and even when i click on Show Missing Values it does not show the last month of the year which the main data source has no info but the related to does.
Can you attach workbook. Images usually take lot of time to resolve the issue
You could just change the axis to fixed:
See attached. Let me know if that works for you!
Retrieving data ...