When I was creating a text table in Tableau, I noticed an “Abc” placeholder column appearing at the end of the table. At first, I thought it was a label I had added, but later I came to know that it’s Tableau’s default placeholder text that appears when no measure is assigned for a dimension.
Later, I was successfully able to remove the ‘ABC’ column from the Tableau text table by customizing the table format.
In this Tableau tutorial, I will explain all possible ways to remove the ABC column in the Tableau text table.
Remove the ABC Column in Tableau
In the examples below, we will discuss four ways to remove the ABC column in Tableau.
- Remove the ABC column in Tableau from the color card
- Remove the ABC column in Tableau by formatting columns
- Remove the ABC column in Tableau using a calculated field
- Remove the ABC column using the Tableau table extension
Remove ABC Column in Tableau From The Color Card
To create the Tableau text table view, I have added the dimensions segment and categories to the Rows. Since there is no measure like sales and profit, the table is showing the ‘ABC’ column.
To remove the ABC column, click on the Color card in the Marks section, then select the Opacity as 0%.
This will not exactly remove the ABC column, but it will hide the ABC values from the column.
Remove ABC Column in Tableau by Formatting Columns
In this method of removing the ABC columns in Tableau, we will format the column settings.
To remove the ABC column, right-click on the table and select Format.
In the Format bar, click on the Border icon at the top, then in the Column Divider select Pane as None.
With this, the column divider will be removed. Now drag the ABC column to the left and make it as small as possible.
Now, the ABC column will be hidden in the chart view. This way, we can remove the ABC column in Tableau by formatting columns.
Remove the ABC Column in Tableau Using a Calculated Field
In this method, we will create a