How to Reorder Columns in Tableau

Moving columns in your Tableau dashboards and reports might seem like a small detail, but it’s fundamental to creating clear, intuitive visualizations. A logical column order turns a confusing table into a compelling story that guides your audience from one insight to the next. This tutorial will walk you through several easy methods for reordering columns in Tableau, from the classic drag-and-drop to a few lesser-known techniques for staying organized.

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 the Order of Your Columns Matters

Before jumping into the “how,” it’s helpful to understand the “why.” The arrangement of your data fields directly impacts how users interpret your work. A well-structured layout does three things:

• Improves Readability: Placing related fields next to each other, like City, State, and Country, makes the data easier to scan and understand.
• Creates a Narrative Flow: You can guide the viewer’s eye strategically. You might start with high-level summary data on the left (e.g., Region) and move to more granular details on the right (e.g., Product Name).
• Enhances Professionalism: A thoughtfully organized table simply looks cleaner and more polished, which builds trust in your analysis. Leaving columns in a random order can make your dashboard feel rushed or incomplete.

Now, let’s get into the practical steps for making it happen.

Method 1: Drag and Drop on the Shelves

The most common and direct way to reorder columns is by interacting with the "pills" on the Columns and Rows shelves at the top and side of your worksheet. This is the method you'll likely use 90% of the time.

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

Reordering Discrete Fields (Blue Pills)

When you place dimensions like Category, Customer Name, or a discrete date on the Columns shelf, Tableau creates a header for each value. Changing their order is as simple as rearranging these pills.

Let's say you have a view showing SUM(Sales) by Region and then Category. The pills on your Columns shelf look like this: [Region] [Category].

1. Navigate to the Columns shelf.
2. Click and hold the [Category] pill.
3. Drag it to the left of the [Region] pill. You will see a small, orange triangle indicating where the pill will be dropped.
4. Release the mouse button.

That’s it! Your table will instantly update, breaking down the view first by Category and then by Region within each category. This method is perfect for changing the hierarchy of your dimensions.

Reordering Measures Using Measure Names

Things work a bit differently when you're working with multiple measures in a text table, like Sales, Profit, and Quantity. In this case, Tableau often uses a special generated field called Measure Names on the Columns shelf and Measure Values on the Text card.

Trying to drag the Measure Names pill won’t work. Instead, you change the order in the Measure Values card, which directly controls the column sequence.

1. Look for the card labeled Measure Values on the left side of the worksheet, likely below the Marks card.
2. This card contains the pills for each measure in your view (e.g., SUM(Sales), SUM(Profit)).
3. Simply click and drag these pills up or down within the card to change their order.
4. The columns in your table will update in real-time to match the new sequence in the Measure Values card.

For example, if you want your table to read Sales, Profit, Discount, ensure that’s the top-to-bottom order of pills in the Measure Values card.

Method 2: Drag and Drop Headers in the View

For quick, visual adjustments, you can reorder columns directly within the visualization itself. This is particularly useful for crosstabs (text tables) where you want to see the effect of your changes immediately.

This method works best with discrete dimension headers (blue pills).

1. Build a text table with at least two discrete dimensions on the Columns shelf (e.g., Segment and Ship Mode).
2. Move your cursor over the header of a column you want to move. For example, hover over the "Consumer" header for the Segment field. Your cursor will change.
3. Click and hold the header. A bold black line will appear, indicating your selection.
4. Now, drag the header left or right. A faint gray line will show where the column will be moved when you release.
5. Release the mouse where you want the new column position to be.

This is a manual sort that overrides the original order. Tableau will remember this custom arrangement, and you can see a small symbol on the corresponding pill in the Columns shelf to indicate a sort has been applied.

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

Method 3: Organize Columns in the Data Pane

While the previous methods rearrange columns in your current worksheet, organizing fields in the Data Pane (the left-hand sidebar) helps structure your entire workbook. This sets the default order and saves you time later.

Changing the Default Field Order

By default, fields in the Data Pane are sorted alphabetically. You can change this to match their order in the data source, which can be immensely helpful if your source table is already well-structured.

1. In the Data Pane, click the small dropdown arrow next to the search bar.
2. Select a different "Sort by" option, such as Data Source Order.
3. Your dimensions and measures will now be listed in the order they appear in the original spreadsheet or database table. This makes it easier to find and add related columns together.

Using Folders for Organization

For workbooks with dozens or even hundreds of fields, folders are a lifesaver. You can group related fields into folders to keep the Data Pane clean and easy to navigate.

1. Again, click the dropdown arrow in the Data Pane search area.
2. Select Group by Folder.
3. Now, to create a folder, simply multi-select the fields you want to group (hold CTRL or Command and click each one).
4. Right-click on any of the selected fields and choose Folders > Create Folder.
5. Give your folder a name, like "Customer Demographics" or "Order Details."

Putting fields into folders doesn't change your visualizations, but it drastically speeds up your building process because you aren’t scrolling endlessly to find the right field.

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

Method 4: Manually Sorting an Individual Column's Values

Sometimes you need to arrange the values within a column rather than the column's position itself. For example, maybe you want your Segments to appear in the order of "Corporate," "Consumer," "Home Office" instead of the default alphabetical order.

1. In the Data Pane, find the field whose values you wish to reorder (e.g., Segment).
2. Right-click the field and navigate to Default Properties > Sort.
3. A dialog box will appear. Select the Manual sort option.
4. From here, you can click on any value and use the up and down arrows to move it to your desired position.
5. Click OK.

Now, whenever you add this field to a view, its values will appear in the custom order you just defined. This allows for logical groupings that alphabetization can’t provide, like sorting survey responses from "Very Satisfied" to "Very Dissatisfied."

Final Thoughts

Mastering column arrangement in Tableau is about taking control of your data's presentation. From a quick drag of a pill on the Columns shelf to meticulously organizing your Data Pane with folders, each method helps you build more effective and easier-to-read reports. A logical structure guides your audience, making your insights resonate more clearly.

While these tools give you precise control, manually arranging every report can become tedious, especially when you need answers quickly. For this reason, we designed Graphed to handle the layout for you. You can ask for a dashboard using plain English - like "Show me sessions vs. conversions by traffic source from Google Analytics" - and we build the visual instantly with a logical and clear layout. Your time is better spent analyzing insights, not just arranging them.