Menu
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.
553
There is a very easy feature within Tableau which enables you to do so. Showing all values of a dimension even if there is NO data (NULL) attached to it! Just navigate yourself to Analysis > Table Layout > Show Empty Columns/Rows at the top of your screen.
Right-click on the Measure pill and select Format. In the format window, go to Pane and hopefully the Special Values will be there. Select Hide in the Special Values section of the pane to hide the Null values.
Go to Analysis >Table layout> Show columns with no data or Analysis>Table layout>Show rows with no data
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
