KNOWLEDGE BASE

Hiding Only the Blank Column when Using Difference Table Calculation


Published: 04 Feb 2013
Last Modified Date: 04 Jul 2017

Question

How to hide a blank column when using a Percent Difference or Difference table calculation without hiding the other measures in the view.

Environment

Tableau Desktop

Answer

Option 1:

If there is more than one measure or dimension in the view, the blank column cannot be hidden without also hiding all instances of that Dimension value. For example, hiding one Q1 column will hide the Q1 column for all years. Use the following workaround if there is only a measure or a dimension in the view.
  1. Right-click the blank column header.
  2. Select Hide.

Option 2:

The following workaround was provided in the Community and found helpful by multiple readers: How to hide a column when showing percent difference.
  1. Select Analysis > Create Calculated Field to create a calculated field.
  2. In the Calculated Field dialog box, type a name and the following formula, and then click OK:
    index()!=1
  3. Drag one copy of the newly created calculated field to Detail on the Marks card and a second copy to the Filters shelf.
  4. In the Filter dialog box, select True, and then click OK.

Option 3

If Measure Names/ Measure Values are used in the view, building a text table view with multiple marks cards might provide more flexibility with cross-tab formatting. For more information, see this blog post: My Favorite Tableau Trick For Work: MIN(1).

Additional Information

To voice your support for the inclusion of this feature in a future release, vote on the Simple Textual Formatting Abilities idea on the Tableau Community Forum.
Did this article resolve the issue?