KNOWLEDGE BASE

Removing "Abc" Placeholder Text


Published: 14 Dec 2016
Last Modified Date: 04 Oct 2017

Question

How to remove the "Abc" placeholder text from a crosstab view. 

Environment

Tableau Desktop

Answer

This example is based on Superstore sample data and starts with a view containing Category and Sub-Category on rows.

Option 1: Create a placeholder field 

  1. Select Analysis > Create Calculated Field
  2. Name the field Blank, enter the following formula, then click OK
    " " 
  3. Place this new "Blank" dimension on the Text mark

Option 2: Change the mark color

  1. Right-click the Abc text in the view and select Format.
  2. Change the pane color to a color that matches the background (e.g., white).
  3. Click the shading icon and decrease the banding size for rows to eliminate row banding.
To view these steps in action, see the video below: 

Additional Information

By default, Tableau  uses "Abc" placeholder text for any values that could potentially be displayed. In cases where you are using only dimensions or discrete values, Tableau leaves the empty column with the "Abc" placeholder text. 

To format the column and row dividers, see Format Borders in the Online Help.
Did this article resolve the issue?