How to Sort Filter Values in Tableau

One of the small but surprisingly frustrating hurdles in Tableau is getting the values in your filter dropdown to appear in a logical order. You might spend hours crafting the perfect chart, but when you add a filter for "Product Tier," it displays as "Basic," "Enterprise," "Pro" - rendering it unintuitive for your end users. This article will walk you through several straightforward methods to command Tableau to sort your filter values exactly how you want them.

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 Tableau Sorts Filter Values Alphabetically By Default

Before jumping into the fixes, it helps to understand why this happens. By default, Tableau sorts the values of most dimension fields alphabetically. This works great for lists of countries or customer names. But for many common business fields, alphabetical order is counterintuitive:

• Time Periods: Months sort as April, August, December instead of January, February, March.
• Sizing or Tiers: A t-shirt size filter might show as "Large," "Medium," "Small," "X-Large."
• Survey Responses: Likert scale answers might display as "Agree," "Disagree," "Neutral" instead of in progressive order.

This default behavior can make dashboards less user-friendly and even lead to confusion. Fortunately, you have complete control to override it. Let's fix this by changing the field's default properties so it's sorted correctly everywhere you use it.

Method 1: Manually Setting the Default Sort Order

This is the most direct method and is perfect for fields with a small, fixed number of values, like product tiers, clothing sizes, or priority levels. By changing the default sort property of the dimension itself, you ensure the values appear correctly every single time you use that field as a filter across your entire workbook.

Let's use an example of a sales dashboard with a filter for "Shipping Container" which has values: "Small Box", "Medium Box", "Large Box", "Jumbo Box". Alphabetically, this would appear as "Jumbo Box", "Large Box", "Medium Box", "Small Box", which is a messy 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-by-Step Instructions:

1. Find Your Dimension: In the Data pane on the left side of your screen, locate the dimension field whose filter values you want to reorder (in our case, "Shipping Container").
2. Open Sort Properties: Right-click on the dimension and navigate to Default Properties → Sort.
3. Choose Manual Sort: A new "Sort" dialog box will appear. You'll see several options. Select Manual sort.
4. Rearrange Your Values: You'll now see a list of all the values in that dimension. Simply click and drag the values to rearrange them into your desired order. For our example, you would drag "Small Box" to the top, followed by "Medium Box," "Large Box," and "Jumbo Box."
5. Apply the Changes: Once you're happy with the order, click Apply, then OK.

Now, if you remove the "Shipping Container" filter from your filter shelf and add it back, the values will appear in the logical, manually set order you just defined. Setting this at the default level is a "set it and forget it" solution - saving you time and headaches later.

Method 2: Sorting a Field Based on Another Field

The manual method is great, but what if you have a long list of values or if the sort order is already defined by another column in your dataset? A classic example is sorting month names. Manually arranging twelve months is certainly possible, but it’s much more efficient to use a corresponding "Month Number" field (1 for January, 2 for February, etc.).

This method tells Tableau: "Hey, when you sort the Month Name field, don't look at the text. Instead, base the order on the value of the Month Number field."

Step-by-Step Instructions:

1. Find Your Dimension: Again, head to the Data pane and locate the dimension you want to sort (e.g., "Month Name"). Make sure its corresponding numeric field ("Month Number") is also in your data source.
2. Open Sort Properties: Right-click on "Month Name" and go to Default Properties → Sort.
3. Sort By Field: In the "Sort" dialog box, under the "Sort by" options, select Field.
4. Choose your Sorting Field: A few new dropdowns will appear.
5. Apply and Close: Click OK. Tableau will now permanently sort your "Month Name" field according to the "Month Number" field.

This approach is incredibly powerful and scalable, making it ideal for everything from fiscal periods and project phases to product lists that have a predefined SKU order.

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: Creating a Calculated Field for Custom Sorting Logic

Sometimes your desired sort order is neither alphabetical nor inherently contained within another numeric field in your database. For instance, you might want to sort a "Subscription Plan" filter as "Free", "Standard", "Pro", and then "Enterprise," but you don't have a plan ID field to sort by.

In this scenario, you can create your own sorting field using a simple calculated field. This gives you complete flexibility to define any custom order you need.

Let's stick with the "Subscription Plan" example.

Step-by-Step Instructions:

1. Create a Calculated Field: In the top menu, select Analysis → Create Calculated Field. Or, right-click anywhere in an empty area of the Data pane and select "Create Calculated Field...".
2. Name Your Calculation: Give it a clear name, like "Subscription Plan Sort Order".
3. Write the Formula: Use a CASE statement to assign a number to each of your subscription plan values. This creates the logic for your sort.

CASE [Subscription Plan]
WHEN "Free" THEN 1
WHEN "Standard" THEN 2
WHEN "Pro" THEN 3
WHEN "Enterprise" THEN 4
ELSE 5
END

The ELSE 5 is a good practice to catch any unexpected new values and place them at the end of the list.

1. Save the Calculation: Click OK. You'll now see your new "Subscription Plan Sort Order" field in the Data pane.
2. Apply the Sort: Now you just need to follow the steps from Method 2.

You've now successfully created a custom sort logic and applied it to your filter. This method is the ultimate solution for complex or non-standard sorting requirements.

Troubleshooting Common Issues

Even with these methods, you might run into a hiccup. Here are a couple of common problems and their quick solutions.

"I set the default sort, but my existing filter didn't update!"

Tableau often doesn't retroactively apply default property changes to elements that are already on a worksheet. If you set the default sort but an existing filter on your view remains in the old order, the simplest fix is to remove the filter from the filter shelf and then drag the dimension back onto the filter shelf. This will force Tableau to re-read the default properties and apply your new custom sort order.

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

"My list is too long for a manual sort."

If you have dozens or hundreds of values, the manual method is not practical. In this case, focus on either Method 2 or 3. The best solution is always to have a corresponding numeric identifier in your source data you can use for sorting (Method 2). If that's not possible, creating a calculated field (Method 3) gives you the control you need without endless dragging and dropping.

Final Thoughts

Wrestling with something as simple as a sort order can be tedious, but getting it right is crucial for creating professional, intuitive dashboards. By mastering these methods - setting default properties manually, by field, or with calculated fields - you can ensure your filters always present information logically and enhance the overall user experience of your reports.

Manually configuring these details in sophisticated BI tools can sometimes feel like you're fighting the software instead of unlocking insights. It’s why we created Graphed. We turn hours of tedious setup into simple, conversational requests, connecting to your data from platforms like Google Analytics, Shopify, and Salesforce. Instead of hunting through menus to fix a sort order, you just describe the dashboard you need, and our AI data analyst builds it correctly - and instantly - letting you focus on answers, not setup.