Show Empty Rows and Columns
Kommentare : 3
Dear Tableaufans,
data analysis is often about “What is IN the data?”. Therefore we sometimes forget to ask the question about “What is NOT in the data?“!!! 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.
With that said – MERRY CHRISTMAS to the DataFam and all Trailblazers!!!
P.S. This feature seems to be secretly released in 2018.3 😉
Pingback: Best of the Tableau Web: Reflections, predictions, and plans | Tableau Software
Hi,
A little clarification on this feature: Show Empty Rows & Show Empty Columns aren’t new features, they’ve been around since at least Tableau 6.1. Also they only work for discrete dimensions and those dimension values can’t have been filtered out by the dimension itself being on Filters, other fields that are context filters, or data source filters.
Regards,
Jonathan
Hi Jonathan,
thx for leaving a comment! Your blog is another great source for Tableau content! Are you sure? So just by going back within the documentation of this feature it seems like it wouldn’t be the case, but maybe the feature was called/referenced differently before? The first version I’ve been using has been 7.x and I can’t remember that it has been available back then (which doesn’t necessarily mean that it didn’t exist! ;))
https://help.tableau.com/v2018.3/pro/desktop/en-us/missing_values.htm –> exists
https://help.tableau.com/v2018.2/pro/desktop/en-us/missing_values.htm –> doesn’t exist