Thank you for your help. But the issue is not that the value for these dates is 0; there's just no data entry for these months in the database.
3 of 3 people found this helpful
The concept you are referring to is Domain Completion or Domain Padding.
Tableau tries to be helpful and auto-complete domains comprised of a DateTime data type.
If your dimension were truly a date-time, you could Show Missing Values
Since your "Dim" dimension appears to be a text-based dimension, Tableau cannot know how to auto-complete the domain of your dimension. Your best bet in that case is to manipulate the source data and force missing data to exist in the source data-set. This can be achieved fairly easily in SQL by utilizing cross-joins if you have a full list of the possible dimensions available.
5 of 5 people found this helpful
Thanks, Mark Holtz,
My issue was very similar, but I do have data for the missing months, they're just all zeros, so Tableau is hiding the columns for me.Your "Show Missing Values" link led me to the Analysis > Table Layout > Show all Columns which solved my issue.
Thank you...that was exactly what I was looking for - and so simple!