How to Sort Bars in Tableau

Sorting bars in a chart sounds simple, but it's one of the most effective ways to make your data understandable. An unsorted bar chart can feel chaotic, forcing your audience to hunt for insights. A properly sorted one, however, tells a clear story instantly. This guide will walk you through the various ways to sort bars in Tableau, from the quick one-click methods to more advanced techniques that give your users control.

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 Sorting Your Bar Charts Matters

Before we jump into the "how," let's quickly touch on the "why." Sorting isn't just about making things look tidy, it's a fundamental part of data visualization that directly impacts comprehension.

• It Highlights Key Performers: Sorting by a value (like sales or profit) immediately draws the eye to the highest and lowest performers. This is crucial for answering questions like, "What are our best-selling products?" or "Which regions need more attention?"
• It Simplifies Comparisons: When bars are arranged in a logical order, it's much easier for viewers to compare a specific category to its neighbors or to the overall distribution.
• It Guides the Narrative: A clean sort order creates a visual path for the viewer to follow, making the story you're telling with your data clear and compelling. An unsorted chart sends the brain in multiple directions at once.

In short, sorting turns a list of data points into meaningful insights. Now, let's get into the practical steps.

The Easiest Ways to Sort: One-Click Options

Tableau provides a few incredibly fast ways to sort without ever opening a menu. These are perfect for quick, on-the-fly analysis while you're exploring your data.

1. Toolbar Sort Icons

This is the most straightforward method. Once you've built your basic bar chart, you'll notice sort icons in your toolbar at the top of the screen (they look like little bar charts with an arrow).

Let's say you have a chart showing SUM(Sales) by Sub-Category.

• Click the Descending Sort icon (from longest to shortest bar) to instantly see your top-performing sub-categories at the top.
• Click the Ascending Sort icon (from shortest to longest bar) to bring the lowest performers into focus.

This method sorts the dimension on your view (Sub-Category) based on the measure (SUM(Sales)). It's fast, efficient, and often all you need for a basic analysis.

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

2. The Axis Sort Button

Another quick option appears right on your chart's axis. When you hover your mouse over the axis that represents your measure (e.g., the Sales axis), a small sort icon will appear.

Simply click this icon to cycle through the sort orders: ascending, descending, and then back to the original default order. This is a great way to toggle between different views without moving your mouse up to the toolbar.

Taking More Control: Sorting by a Specific Field

While the one-click methods are great, you'll often want more control. The most common and flexible way to do this is by sorting a dimension based on the value of a specific field, which may or may not be the one used to create the bar lengths.

This is done through the Sort dialog box. Here's how to access and use it:

1. Find the blue dimension pill that defines your bars (e.g., [Sub-Category]) on either the Rows or Columns shelf.
2. Right-click on the pill and select Sort from the dropdown menu.

This opens a new window with several options. Let's focus on the most popular one.

Sort by Field

Inside the Sort dialog, you'll see a "Sort by" option. By default, it might be on "Data Source Order" or "Alphabetic".

• Change the "Sort by" dropdown to Field.
• Leave the "Sort Order" as Descending to see the highest values first.
• In the "Field Name" dropdown, select the measure you want to sort by. If your chart shows sales, Tableau intelligently defaults to Sales. You can, however, choose any other measure in your dataset. For example, you could show sales bars but sort them by Profit or Quantity.
• Confirm the "Aggregation" is what you want (e.g., Sum, Average). It usually defaults correctly based on what's in your view.
• Click OK.

Your chart is now definitively sorted by the field you chose. This method is incredibly useful because it's explicit. You're telling Tableau exactly how to order the data - no guesswork involved. This sort will also stick, even if you change other things in the view, unlike the quick-sort toolbar options which can sometimes reset.

Advanced Sorting Techniques for Deeper Insights

Once you've mastered the basics, you can apply sorting in more sophisticated ways to answer more complex questions and build more dynamic dashboards.

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

1. Computed Sorts (Using a Calculated Field)

What if you want to sort by a metric that doesn't exist yet, like Profit Ratio? This is where computed sorts come in. You can sort a dimension by a custom calculation.

Let's say you want to sort your Sub-Category bars (which show total sales) by their profit ratio (Profit / Sales).

1. First, create the calculated field. Go to Analysis > Create Calculated Field. Name it "Profit Ratio" and enter the formula: SUM([Profit]) / SUM([Sales])
2. Right-click your [Sub-Category] pill and choose Sort.
3. In the dialog box, set "Sort by" to Field.
4. For "Field Name," scroll down and select your newly created Profit Ratio calculated field.
5. Set the order to Descending to see the most profitable sub-categories first.

This is incredibly powerful. Your chart is still visualizing sales, but the order in which the bars are presented is driven by an entirely different metric of profitability. This helps you spot sub-categories that might have high sales but low profitability, an insight that would be missed otherwise.

2. Nested Sorting (Sorting within a Category)

Nested sorting is useful when you have multiple dimensions in your view. For example, imagine you have a bar chart showing Sales broken down by both Category and Sub-Category.

By default, Tableau might sort the sub-categories alphabetically within each category. But what you really want is to see the sub-categories sorted by their sales within each parent category.

1. Build your view with both [Category] and [Sub-Category] on the Rows shelf, and SUM(Sales) on the Columns shelf.
2. Right-click the inner dimension pill, which is [Sub-Category] in this case.
3. Select Sort.
4. Set "Sort by" to Field, and choose Sales as the field name.
5. Select Descending.

Tableau will now independently sort the sub-category bars within each category, giving you a much clearer understanding of performance at a granular level.

3. Manual Sorting for Custom Order

Sometimes, your desired sort order isn't based on value or alphabet but on a custom, business-defined logic. For example, maybe you want to display survey responses ("Poor," "Fair," "Good," "Excellent") in that specific order, not alphabetically.

1. Right-click the dimension pill you want to sort (e.g., [Survey Response]) and select Sort.
2. In the dialog box, choose "Sort by" > Manual sort.
3. You'll see a list of the dimension's members. Simply click and drag them into the order you need.
4. Click OK.

A quicker way to do this for a few items is to simply click and drag the headers directly in the chart view itself to reorder them on the fly.

Bonus Pro-Tip: User-Controlled Sorting with Parameters

For the ultimate interactive dashboard, you can let your end-users decide how they want to sort the data.

This involves using a Parameter and a Calculated Field. It might sound complex, but it's a game-changer for user experience.

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 1: Create a Parameter

• In the Data Pane, right-click and choose Create Parameter.
• Name it "Sort by…"
• Set the Data Type to String.
• Under Allowable values, select List.
• In the list, type in the names of the measures your users can sort by (e.g., "Sales," "Profit," "Quantity").
• Click OK. Then, right-click the parameter and select Show Parameter.

Step 2: Create a Corresponding Calculated Field

• Create a new Calculated Field and name it something like "Selected Sort Measure".
• Use a CASE statement to link the parameter to the actual measures:

CASE [Sort by…]
WHEN "Sales" THEN SUM([Sales])
WHEN "Profit" THEN SUM([Profit])
WHEN "Quantity" THEN SUM([Quantity])
END

Step 3: Apply the Sort

• Now, right-click your main dimension pill (e.g., [Sub-Category]) and choose Sort.
• Set "Sort by" to Field.
• For the "Field Name," select your new calculated field, "Selected Sort Measure."
• Click OK.

Now, your dashboard will have a dropdown menu. When the user selects "Profit," the "Selected Sort Measure" field calculates the SUM of Profit, and your bar chart will re-sort accordingly. They can switch to "Sales" or "Quantity," and the chart will update instantly. This single feature can dramatically elevate the professionalism and utility of your dashboards.

Final Thoughts

Mastering how to sort bars in Tableau is a fundamental skill that transforms static charts into powerful, storytelling tools. From simple one-click sorts for discovering top performers to dynamic parameter-driven sorting that empowers your users, each method adds another layer of clarity and professionalism to your work.

While mastering tools like Tableau is a valuable skill, the process of configuring sorts, writing calculated fields, and setting up parameters still requires time and clicks. At Graphed, we've streamlined this process by allowing you to simply state what you need. Instead of clicking through menus, you can just ask, "Show me my top 10 products sorted by sales" or "Build a dashboard comparing profit and sales by category," and Graphed generates the interactive visualizations for you in seconds - already sorted and ready for analysis.