How to Add More Than 16 Columns in Tableau

You’ve hit the wall. You're building a detailed text table in Tableau, dragging discrete fields to the Columns or Rows shelf, and after the 16th pill, Tableau simply stops creating new columns. This frustrating and common limitation can feel like an arbitrary roadblock when you’re trying to build a comprehensive report. This tutorial will show you exactly how to bypass Tableau’s 16-column limit and also explore why better visualization practices might be the real answer.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Does Tableau Have a Column Limit?

Before diving into the fix, it’s helpful to understand why this limit exists in the first place. Tableau is fundamentally a data visualization tool, designed to help you spot trends, patterns, and outliers visually. Its creators built it around the principle that massive text tables (or crosstabs) are often an inefficient way to analyze data compared to charts and graphs. A table with 20 or 30 columns is difficult for the human brain to process and is closer to a spreadsheet than a visual analysis.

The 16-column restriction for discrete fields is a technical and philosophical boundary. It subtly encourages users to think more visually about their data. That said, sometimes you have a stakeholder who absolutely needs a wide, spreadsheet-style report. For those moments, you need a workaround. There are two primary methods to break past this barrier.

Method 1: The Quick Fix by Adjusting Table Layout Options

The most direct way to add more than 16 columns is to simply tell Tableau to increase its built-in limit. This control is tucked away in the table options menu. Follow these steps to adjust it.

Step 1: Open the Advanced Table Layout Menu

Navigate to the top menu bar in your Tableau worksheet. Click on Analysis, then hover over Table Layout to reveal a sub-menu. From there, select Advanced...

This will open a dialog box titled "Table Options." This menu controls the fundamental structure of your text tables or crosstabs.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Increase the Maximum Levels for Row and Column Labels

In the "Table Options" window, you will see a section for "Rows" and "Columns." Both have a field called “Maximum levels of [row/column] labels.” By default, both of these are set to 16.

This number dictates the maximum number of discrete fields (blue pills) that you can place on the Rows shelf and Columns shelf, respectively. To fix your issue, you just need to increase these numbers.

• If you need more than 16 columns, increase the number in the "Columns" section.
• If you need more than 16 rows of headers (a less common scenario), increase the number in the "Rows" section.

You can change this number to anything up to a maximum of 50. For example, if you need 25 columns, simply change the default value from 16 to 25 and click OK.

Step 3: Add Your Additional Fields

Once you’ve applied the change, Tableau will immediately allow you to drag more discrete pills onto the shelf. You’ll be able to continue building out your wide table until you reach your new, higher limit.

A Word of Caution on Performance

While this is an easy fix, there's a reason Tableau sets the default at 16. The more columns you add, particularly with large datasets, the more you can impact the performance of your workbook. Each additional column requires Tableau to run more queries and render more data, which can slow everything down. If your table starts lagging, you may need to reconsider if such a wide table is necessary or explore other methods.

Method 2: Combine Fields with Concatenation

Another clever way to get around the column limit is by combining multiple data fields into a single calculated field. This technique, known as string concatenation, merges several text fields into one, which Tableau then treats as a single column. This approach is perfect when you just need to display related information together, like a full name or a complete address.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Create a Calculated Field

In the Data pane (on the left side of your workspace), right-click and select Create Calculated Field. This will open the calculation editor.

Step 2: Write the Concatenation Formula

Let's say you want to combine a customer’s first name and last name into a single "Full Name" column. The formula would be:

[First Name] + " " + [Last Name]

Here, the + operator joins the text strings together, and the " " adds a space in between them. A more complex example could be creating a full location string from City, State, and ZIP Code fields:

[City] + ", " + [State] + " " + STR([Zip Code])

Note: We used the STR() function around [Zip Code]. Concatenation only works on text strings. If you have numerical fields (like a ZIP code or a date) that you want to include, you must first convert them into strings using the STR() function.

Step 3: Use the New Calculated Field

Once you save your calculated field, it will appear in your Data pane. You can now drag this new field onto the Rows or Columns shelf just like any other field. What was previously three or four separate columns (e.g., City, State, Zip Code) now only consumes one column slot, helping you stay under the limit while still displaying the information you need.

Pros and Cons of Concatenation

• Pros: A great way to group related data logically, save space, and neatly get around the column limit without impacting performance significantly.
• Cons: The combined field is treated as a single piece of text. You can't sort or filter by the individual parts anymore (e.g., you can't sort the concatenated field by State). The formatting is also fixed, which can be a limitation.

Thinking Differently: Alternatives to Wide Tables

Exceeding the 16-column limit is often a sign that a text table might not be the best tool for the job. While you now have the tools to force it, take a moment to consider if a different approach could tell a more compelling and clearer data story.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Use Tooltips to Provide Detail

Instead of cramming every piece of data into dozens of columns, keep your main table simple and focused on key metrics. Then, move all the secondary information into the tooltip.

To do this, drag all the additional fields you want to show onto the Tooltip tile in the Marks card. Now, when a user hovers their mouse over a row or mark in your visualization, a pop-up box will appear showing all the relevant details. This gives users access to everything they need without cluttering the screen.

2. Create a Dashboard with Linked Worksheets

Another powerful strategy is to split your giant table into several smaller, specialized views and combine them on a dashboard. For example:

• Create a bar chart showing Sales by Region.
• Create a second sheet with a moderately sized text table showing customer and order details.

On a new dashboard, place both of these sheets. Then, set up a dashboard action that uses the "Sales by Region" chart as a filter. Now, when a user clicks on the "West" region bar, the text table instantly filters to show details for only the West. This interactive approach is more engaging and less overwhelming for your audience.

Final Thoughts

Tableau’s 16-column limit for discrete pills is a deliberate design choice to encourage visual best practices, but it's not an unbreakable rule. By diving into the Analysis > Table Layout settings, you can quickly increase the limit up to 50, or you can use calculated fields to cleverly concatenate and combine multiple data points into a single column.

While mastering these workarounds is useful, we believe the experience of analyzing data shouldn't involve hunting for hidden settings menus or writing custom formulas. We built Graphed because we wanted to eliminate this friction. Instead of fighting with complex tools, you can simply connect your data sources like Google Analytics, Shopify, or Salesforce and ask for what you want in plain English. Just ask, "build a dashboard showing my top 25 products by revenue, including category, sales region, and campaign source," and our AI creates it instantly, no column limits or calculations required.