KNOWLEDGE BASE

Removing "Abc" Placeholder Text


Published: 14 Dec 2016
Last Modified Date: 30 Aug 2019

Question

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

Environment

Tableau Desktop

Answer

All of these options are demonstrated in the attached workbook.
 
CLICK TO EXPAND SOLUTION

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 the steps showed in the below video, please expand the above section.
Note: the 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.

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