How to Sort Bar Chart in Descending Order in Tableau

When you create a bar chart, you want it to tell a clear and immediate story. Placing your bars in descending order is one of the fastest ways to show what’s performing best and what isn't, but getting Tableau to cooperate can sometimes feel like a puzzle. This tutorial breaks down every method for sorting a Tableau bar chart, from the simple one-click solution to more advanced techniques for custom sorting.

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 Bother Sorting Bar Charts?

Before jumping into the "how," it’s helpful to understand the "why." An unsorted bar chart is just a collection of data, a sorted bar chart is an insight. Sorting in descending order immediately answers critical business questions like:

• Which products are our top sellers?
• Which marketing channels are driving the most traffic?
• Which sales regions have the highest revenue?
• Which support agents are closing the most tickets?

By arranging your categories from highest to lowest value, you draw your audience's eye directly to the most important metric. This simple design choice transforms your chart from a simple data visualization into a powerful decision-making tool. It removes the mental work required to compare bars and instantly surfaces your winners.

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

First, Let's Build a Basic Bar Chart

To have something to sort, we first need a chart. We'll use the "Sample - Superstore" dataset that comes with every version of Tableau. Our goal is to create a simple bar chart showing Sales by Sub-Category.

If you're already comfortable with this, feel free to skip to the next section. If not, here are the steps:

1. Open Tableau and connect to the "Sample - Superstore" dataset.
2. In the Data pane on the left, you'll see your Dimensions and Measures.
3. Drag the Sub-Category dimension onto the Rows shelf.
4. Drag the Sales measure onto the Columns shelf.

That's it! Tableau will automatically generate a horizontal bar chart. You'll likely see the Sub-Categories listed alphabetically, like "Accessories," "Appliances," "Art," and so on. Now, let's sort this to make it more useful.

Method 1: The One-Click Toolbar Sort (The Easiest Way)

Tableau provides quick sort buttons in the toolbar at the top of the worksheet that work for most simple scenarios. This is your go-to method for a quick descending or ascending sort.

Step-by-Step Instructions:

1. Look at the toolbar directly above your worksheet shelves.
2. You'll see two small bar chart icons, one for ascending order and one for descending order.
3. Hover over them. You'll see tooltips that say "Sort Ascending" and "Sort Descending."
4. Click the Sort Descending icon (the one with the tallest bar on the left).

Your chart will instantly reorder itself, placing the Sub-Category with the highest sales ("Phones") at the top and the one with the lowest sales ("Fasteners") at the bottom. This one-click method is fast, efficient, and perfect for getting a quick view of your top performers.

Method 2: Using the Sort Icon on an Axis

Another incredibly simple method is to use the hidden sort icon on the chart's axis itself. This feels more intuitive because you're directly interacting with the element you want to sort.

Step-by-Step Instructions:

1. Move your mouse cursor over the "Sales" axis label at the bottom of your horizontal bar chart (or the left axis for a vertical chart).
2. A small, faint chart icon with an arrow will appear to the right of the axis title.
3. Click this icon once to sort descending. Click it again to sort ascending. Click it a third time to clear the sort and return to the original order.

This method accomplishes the same thing as the toolbar button but keeps your workflow focused on the chart itself. It's often the quickest way to apply and clear a sort while you're exploring your data.

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: Sorting from the Dimension Pill

Sometimes the one-click methods don't behave as expected, especially in more complex visualizations with multiple dimensions. Sorting directly from the dimension "pill" on your Rows or Columns shelf gives you much more control and access to a detailed sort menu.

Step-by-Step Instructions:

1. Locate the blue Sub-Category pill on your Rows shelf.
2. Right-click the pill (or click the small dropdown arrow that appears when you hover over it).
3. From the context menu, select Sort.
4. A "Sort" pop-up window will appear. This is where you can define exactly how your dimension should be ordered. Let's explore its options.

Breaking Down the Sort Dialog Box

Inside this window, you get several choices for "Sort by." Here's what they mean:

• Data source order: Sorts the categories based on their order in the underlying data source. For many sources, this ends up being alphabetical.
• Alphabetic: Sorts alphabetically, A-Z (ascending) or Z-A (descending).
• Field: This is the option you'll use most often. It lets you sort your dimension (Sub-Category) based on the value of a specific measure (Sales).
• Manual: Allows you to drag and drop the categories into any specific order you need. This is great for things that have a natural but non-alphabetical or non-numeric order, like "Small, Medium, Large."
• Nested: This advanced option is for scenarios where you have multiple dimensions, and you want to sort one dimension within the context of another.

How to Sort Descending Using the "Field" Option

1. In the Sort dialog, select Sort by: Field.
2. Next to "Sort Order," choose Descending.
3. For "Field Name," select Sales (it should already be selected if it's the only measure in your view).
4. The "Aggregation" should be set to Sum, which is how our Sales value is being calculated.
5. Click OK or simply close the window.

Your chart is now sorted by the sum of sales in descending order. This method is the most robust and explicit way to tell Tableau precisely how you want your visualization sorted, which can prevent unexpected behavior in complex dashboards.

Sorting by a Field That Isn't in the View

What if you want to sort your Sub-Categories by a metric that isn't currently visualized, like Profit or Discount?

Let's say you want to see which Sub-Categories have the highest sales, but you want to order them by their average profit instead. This is where sorting from the dimension pill truly shines.

1. Using our existing chart of SUM(Sales) by Sub-Category, right-click the Sub-Category pill on the Rows shelf and select Sort.
2. Choose Sort by: Field and Sort Order: Descending.
3. Under "Field Name," click the dropdown. You can now choose any field from your data source, even if it's not on the shelves.
4. Select Profit as the field to sort by.
5. Change the aggregation to Average if you want to sort by average profit per transaction, or leave it as Sum to sort by total profit.
6. Close the dialog box.

Now, your bar chart still shows the total sales for each category, but the order of the bars is determined by their total profit. You might see that "Copiers" moves up the list, as it's highly profitable despite not having the highest sales. This powerful technique lets you layer insights into a single chart.

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

Common Sorting Problems and Troubleshooting

• Why isn't my sort working? Occasionally, a quick sort won't stick because a more specific sort has already been applied from the dimension pill. To fix this, right-click the dimension pill, open the Sort menu, and click "Clear" at the bottom left to reset it. Then try applying a one-click sort again.
• Sorting is greyed out: If your field is part of a blend and comes from a secondary data source that is not active, you may not be able to sort by it directly. Ensure you're using fields from the primary source for sorting wherever possible.
• Table Calculations: Sorting by a table calculation (like Percent of Total or Rank) can be tricky. In these cases, you almost always need to sort from the dimension pill's menu, and the table calculation needs to be in your view for Tableau to "see" it as a sorting option.

Final Thoughts

Sorting a bar chart in Tableau is a fundamental skill that dramatically enhances the readability and impact of your dashboards. While the simple toolbar and axis icons handle most use cases, understanding how to use the full Sort dialog from the dimension pill gives you the precise control needed for creating truly insightful and professional-grade visualizations.

While mastering tools like Tableau is a valuable skill, it often involves a learning curve and time spent navigating menus just to get a straightforward report. This is where tools that simplify the entire process become invaluable for marketing and sales teams. With Graphed , we remove these technical hurdles by letting you use simple conversational language. Instead of clicking through menus, you can just ask, "Show me my Shopify sales by product for the last quarter, sorted with the highest sales at the top," and our AI instantly builds a live, interactive chart for you, saving you the time and hassle of manual report building.