Preventing Auto-Concatenation of Dimension Rows or Columns

KNOWLEDGE BASE

Preventing Auto-Concatenation of Dimension Rows or Columns

Published: 30 Jun 2017
Last Modified Date: 17 Jun 2020

Question

When more than six (6) fields are placed in Columns/Rows, you notice that the first two fields are grouped, separated by a comma. This article describes how to prevent the auto-concatenation of the fields.

Environment

Tableau Desktop

Answer

Option 1

Upgrade to Tableau Desktop 2019.4 or later.

Option 2

If you cannot upgrade, follow these steps:

Select Analysis > Table Layout > Advanced
Adjust the number of Rows or Columns (Default is 6) as desired.

Important: Prior to Tableau 2019.4 the maximum number of discrete fields on the Rows shelf was 16. As of Tableau version 2019.4, the maximum number of discrete fields on the Rows shelf is 50, while the maximum number of discrete fields on Columns shelf is 16.