Tableau table hides categories with no data - how to prevent?

tableau-api
curtisp picture curtisp · Nov 9, 2014 · Viewed 36k times · Source

I have Tableau report where I am showing data by category in columns.

The table shows all columns when there is no filter on data. But when filter is applied, some of the categories do not have data, so table shrinks, hiding columns without data

Is there a way to always show columns regardless of data or not in that column?

Please see screenshots below.

enter image description here

Answer

user4895527 picture user4895527 · May 13, 2015

Go to Analysis >Table layout> Show columns with no data or Analysis>Table layout>Show rows with no data

Related questions

How to display 40 + columns in Tableau?

I am trying to do a list report with about 40 columns(Dims+measure) but not able to get it right, the requirement pushes the Tableau limitation by exploiting its limit to only 16 columns. How can I get this done? I …

Read More
In tableau, how do you modify the number of decimals of a percentage label?

In tableau, how do you modify the number of decimals of a percentage label? On bar charts, histograms, maps, etc.

Read More
How do I show an axis in Tableau

How can I re-enable the y-axis on the following line graph? I have tried right clicking various places with no success.

Read More