go to Analysis>Table Layout and select to show empty rows/columns (depending on where you put your month field).
as long as you have some data somewhere in your dataset for that month it will show in the table.
i have done that but still only for four months values are coming , remaining 8 months are not displayed
If your month data is continuous, you might try creating a transparent reference band. You can use two calcs to make sure it always stretches across the 12 months that you need.
You should also set your [Date] to Show missing values, though the reference band "door stop" may make this unnecessary.
As for the filter... set your [Date] to apply to all worksheets, however you may have to repeat the "door stop" process manually. Good luck! --Michael
You have 2 types of date field you can use in Tableau. Discrete (blue) and continuous (green). Discrete creates "groups" of date while "continuous" displays a data point for each date in time.
You could use a "continuous" date field in your visualization to display all the dates (at the level you chose: year/quarter/month/day). It will display the dates where you have null data:
-continuous (right click date field in column> select bottom part
(in the example I chose a continuous "day" level)
Discrete (top part) would display only the days where I have data:
>13,15 and 18 are missing because no data to display
Hope this helps!
A bit more about Tableau date type here:
Thanks for replies ,
but if i have data for only four months say march , April , June , July , then also i want to display all 12 months in report.
If you data is continuous, the method I outlined above should work. The "transparent reference band" prevents the graph from being compressed. And since it's invisible, your viewers will never know it's there.
Are you interested in specifics?
it seems very similar to this Show Months w/ No Data on Line Graph
You may try and in case the example with today() calculation use this to obtain December (current year):
dateadd('day', -1, datetrunc('year',dateadd('year', 1, today())))
or a date parameter.