Geek Answers Handbook

Table table hides categories without data - how to prevent?

I have a Tableau report where I show data by category in columns.

The table shows all columns if there is no filter on the data. But when a filter is applied, some categories have no data, so the table is compressed, hiding columns without data

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

See screenshots below.

enter image description here

+7
tableau
source share
3 answers

Go to Analysis> Table Layout> Show Columns Without Data or Analysis> Table Layout> Show Rows Without Data

+5
source share

The next step depends on whether your “disappearing” fields are dimensions or dimensions.

If you want to force display of elements for specific dimensions, then one (complex) solution is to use the extended Tableau function, called data blending, to force the existence of dimension elements, even if there are no corresponding measure values. The trick is to create a simple data source , for example, a text file listing the members of each dimension. Use this source as the primary data source and make the original data source a secondary source.

+1
source share

Go to "Analysis"> "Table"> "Show columns without data" or "Analysis"> "Table"> "Show rows without data"

You can also right-click on the title and choose to show missing values ​​if you are using a line chart.

+1
source share

More articles:


All Articles