The only way to do this is through the data source. Tableau can only show the matadata which is being supplied. The only exception i know of is when you have a date field. In date field you can use show missing values(click on the field in rows or columns shelf and you get the option to add missing values) and add data for missing dates. You can try it with country as well but make sure your county field is being identified as a geography field, thats the only way it can be possible. Othen then that you may use a relational DB like OLAP as a data source if possible which should help you with your issue.
If your datasource has a whole set of unique values
for a specific Dimension (domain complete),
then you could build a cross-tab view in Tableau
and use a simple Table Calculation like LOOKUP(ZN(SUM([Sales])),0)
to fill "empty" cells -- even if there are no rows in your datasource
for a particular combinations of dimension values.
If a domain is incomplete, then you could build
a Scaffold datasource, which is essentially a cartesian
of all unique dimension values on a view. You would build
a view with dimensions from this Scaffold DS (called Primary DS).
Then you would use data blending to aggregate relevant Measures
from Secondary DS (your original one with actuals) into Marks
on a view build from Primary DS. This would get the result.
Please find the attached wb
with an example of the first approach.
Hope it would be sufficient in your case.
Example wb.twbx 1.2 MB
I haven't opened your file yet.
But my data source doesn't have the entire list of country names. If a sale is made, then only it will be reflected in my data source as a transaction. So until sales from all corner of the globe comes up, only then I have a full country list.
But management wants to see which countries are still 0 sales on a daily basis.
out of curioistiy, will creating a parameter and then linking the names to the existing dimension work?
That makes sense, so I have to have a separate document will a full namelist?
I have to make dashboards by several dimensions.
The first is country so I need a separate excel with all the country names I need.
Then I also need it by category ( I have 3 categories) and also by division (3 divisions). since there are several permutations here, I am not sure if a simple list will do? Sorry, quite new to this and already tasked with difficult stuff.
I have 7 countries, 3 divisions and 9 categories
You may have an Excel file with every dimension on a single sheet.
To make a cartesian (cross-join) on every dimension,
you would like to use a "dummy" join field (I called it Link ID)
with a single value in it (say 1).
Please take a look at the Scaffold.xslx file attached above.
Hope this makes things clear.
I drag the link country from the scaffold file. and then put in the sales quantity to the sheet and then I do a filter by year to take away the previous year (which has all the countries) to see only this year (which has only 2 countries) and it only shows two, I wanted it to be static.
Please show me a screen of what you've done.
You have to use both Country and Date dimensions from a Primary (Scaffold DS).
Only ZN(SUM(Sales)) would come from a Secondary DS.