Can you please share your data/twbx as ZN,IFNULL functions should work if you want to replace NULL with other value(0 for ZN and other value for IFNULL)
If there is literally no record(s) in the data set you can create a "Date Scaffold" (an excel sheet with a list of all dates) and Join it with your data set based on date -
yo would then use the scaffold dates to create your views
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I can not share data or twbx file
Check to see that your Dimension is selected as a Date type then you should be able to Show Empty Columns and the months with no data within the data shown should display (Tableau is smart enough to fill in the blanks). If you want to display 0 in those months, what Jim suggested above is correct. You'll need to create a separate Date table with the full range of "available" dates and join or blend them on the date dimension with your dataset to then show data available within the desired date range.
I hope this helps!
Thanks for all efforts you making i tried all possible way i also try ZN(LOOKUP(SUM([measure name]),0 )) but its not helping me. I am using year as attribute and in detail have used year >exact date used as discrete.
This is strange i am using same thing for my other report and i can see all 12 months with data and without data, it is showing 0.
Create a excel sheet with date range in the format you want and then join the excel sheet with your data using left join(excel first). So you can get all the date fields.Then you can use ZN() while visualizing data.
Hope this will help.