KNOWLEDGE BASE

Removing "Abc" Placeholder Text


Published: 14 Dec 2016
Last Modified Date: 17 Aug 2018

Question

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

Environment

Tableau Desktop

Answer

Both of these options are demonstrated in the attached workbook
CLICK TO EXPAND STEPS
Option 1: Use Polygon mark type
  1. On the Marks card in the dropdown menu, select Polygon
  2. Resize the last column to make it smaller
  3. Navigate to Format > Borders
  4. In the left-hand Format Border Pane, for Column Divider, For Pane, select None from the dropdown menu
  5. Navigate to Format > Shading
  6. In the left-hand Format Border Shading, for Row Banding, move the slider to the desired level of row banding
CLICK TO EXPAND STEPS
Option 2: Place the last dimension on Text
  1. Drag a second copy of the last dimension on the Rows shelf to Text on the Marks card
  2. Right-click on the last dimension on the Rows shelf and uncheck Show Header
CLICK TO EXPAND STEPS
Option 3: For earlier versions of Tableau Desktop

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

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. 
Note: video has no sound

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.
Did this article resolve the issue?