KNOWLEDGE BASE

Bins do not contain all expected values in Tableau Desktop


Published: 08 Mar 2019
Last Modified Date: 22 Sep 2019

Issue

Bins do not contain all expected values. 

Environment

  • Tableau Desktop 

Resolution

Option 1
Manually turn on Show Missing Values by right clicking the bin in the view and selecting.

Option 2
To show the missing values select Analysis > Table Layout > Show Empty Rows/Columns.

 

Cause

New sheets will not Show Missing Values if the feature is selected in a different worksheet for the same bin, as Show Missing Values is worksheet specific.
 

Additional Information

The only time 'Show Missing Values' will be selected automatically is when first creating a bin and placing it on the worksheet it was created on. Any other instances, such as placing the bin in a new worksheet or clearing the worksheet and placing a bin in the view, will not have Show Missing Values selected. 




Discuss this article... Feedback Forum
Did this article resolve the issue?