Ask Sawal

Discussion Forum
Notification Icon1
Write Answer Icon
Add Question Icon

How to remove abc in tableau?

2 Answer(s) Available
Answer # 1 #

This article will show you five options to hide the abc column.

The abc column appears when there is no pill on the Text shelf when the mark type is text. For example, when creating a table in Tableau using only discrete (blue) pills on Rows, the abc appears.

There are a number of different ways to hide the abc column. Some have more steps than others, choose whichever you prefer.

One way to get rid of the abc is to put a value there. Using this technique it is necessary to create the column header.

To begin put a field on to the Text shelf. It should be the final field in the table. Notice it doesn’t have a column heading. Therefore, to build the header, place the field to the Columns shelf. The header should now say “No Measure Value”. Right-click that label and “Edit Alias…”. Set the column name by editing the alias.

This method also doubles as a way to squeeze an additional column in a table. Pre-Tableau 2019.4 the maximum allowable number of discrete columns in Tableau is 16. Since then it is 50 columns.

Create a calculated field with the formula “”. For example, with the field called Blank:

: ""

Put this field to the Text shelf, which replaces the abc with a blank. However this doesn’t remove the column, therefore it should be disguised.

To disguise it:

With this method there is no need to create a calculated field.

Finally, another option is to format the font, setting the font the same colour as the background.

From the menu bar: Format – Font – Sheet – Pane

As above, reduce the width of the column and format the borders.

Another simple formatting option. Click the Colour shelf and reduce Opacity to 0%.

Again, reduce the width of the column and format the borders to disguise its existence.

I have created a simple example of all of the above options to download from Tableau Public. The dashboards are embedded below and you can also click through directly to the Tableau Public site.

Redge Selznick
Chief Privacy Officer
Answer # 2 #
  • Identify the fields which are causing the 'abc' issue.
  • Drop the identified dimension column from step 1 to both 'rows' and to the 'Text' mark.
  • Right click on the Row dimension pill and un-check the show header option.
Eric ejikb