How to Sort Parameter Values in Tableau

Tableau parameters are incredibly powerful for creating interactive dashboards, but getting their dropdown lists to sort exactly how you want can be surprisingly tricky. By default, Tableau might sort your parameter values alphabetically or in the order they were first created, which often isn't what your users need. This article will show you a reliable and straightforward method to sort parameter values in any order you choose - be it ascending, descending, or a completely custom arrangement.

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 Default Sorting Doesn't Always Cut It

In data visualization, user experience is everything. An unsorted or poorly sorted dropdown list can confuse users and make your beautiful dashboard feel clumsy. While alphabetical sorting works perfectly for things like country names, it falls apart in many common business scenarios.

Imagine seeing a list of months sorted alphabetically: April, August, December, February... It's technically sorted, but it's completely unhelpful for analyzing trends over time. The same goes for any values that have a natural, non-alphabetical order:

• Shirt Sizes: Alphabetical sorting would give you "Large," "Medium," "Small," "X-Large" - a jumbled mess.
• Satisfaction Levels: You’d want "Very Dissatisfied," "Dissatisfied," "Neutral," "Satisfied," "Very Satisfied," not an alphabetical list.
• Sales Tiers: "Gold," "Silver," and "Bronze" have an established hierarchy that alphabetical sorting ("Bronze," "Gold," "Silver") ignores.

To create a truly professional and intuitive dashboard, you need to control this sort order. The good news is that with one simple trick, you can take full command of how your parameters are displayed.

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

The Solution: Sorting with a Dedicated Calculated Field

Here’s the core concept you need to understand: you can't directly sort a parameter itself. Instead, you sort the underlying field that you're using to populate the parameter's list of values.

The entire process boils down to creating a companion calculated field whose only job is to assign a numerical order to the values of your original field. Once you link that sort order to your original dimension, any new parameter created from it will automatically inherit that correct sort order. Let’s walk through the exact steps.

Step-by-Step: How to Sort Your Tableau Parameter

For this example, let's say we have a field named [Project Status] containing the values "Completed," "In Progress," "On Hold," and "Not Started." Alphabetically, "Completed" would come first, which is likely the last status you want to see at the top of your list. We want a logical flow: Not Started, In Progress, On Hold, Completed.

Step 1: Create the 'Sort Order' Calculated Field

First, we need to create a new calculated field that assigns a number to each status, representing our desired order.

1. Navigate to the top menu and select Analysis > Create Calculated Field.
2. Name this new field something intuitive, like Project Status Sort Order.
3. In the formula box, we’ll use a CASE statement. This is generally cleaner and easier to read than a series of IF/THEN statements for this purpose.

Enter the following logic into the formula box:

CASE [Project Status]
WHEN "Not Started" THEN 1
WHEN "In Progress" THEN 2
WHEN "On Hold" THEN 3
WHEN "Completed" THEN 4
ELSE 5
END

A quick note on this formula: The ELSE 5 is a fantastic best practice. It acts as a safety net. If a new status ever appears in your data (like "Cancelled"), this ensures it gets assigned a number and appears at the end of the list instead of being ignored or causing an error.

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 2: Apply Your New Sort Order to the Dimension

Now that you have your sort field, you need to tell Tableau to use it to sort the original [Project Status] dimension.

1. Find your original dimension — [Project Status] — in the Data pane on the left side of your screen.
2. Right-click on the [Project Status] field.
3. From the context menu, go to Default Properties > Sort.
4. A dialog box will appear. Here's how to configure it:
5. Click OK.

You've now successfully configured the default sorting behavior for the [Project Status] dimension across your entire workbook. Any time you pull this field into a view or use it to populate a list, it will follow the order you defined.

Step 3: Create (or Rebuild) Your Parameter

This final step is crucial. The sort order you just set is not applied retroactively to parameters that already exist. You'll need to create a new parameter or clear and repopulate your old one.

1. Right-click in an empty area of the Data pane and select Create Parameter.
2. Give your parameter a name, like "Select Project Status."
3. Set the Data type to String.
4. Under Allowable values, choose List.
5. A new section will appear. Click the Add values from button.
6. From the dropdown, select the [Project Status] field.

Tableau will now populate the parameter list with the values from your dimension, automatically respecting the custom sort order you established in Step 2. Your list will appear perfectly ordered! Right-click on your new parameter and select "Show Parameter" to see it in action on your worksheet.

Advanced Tips and Common Scenarios

This technique is incredibly versatile. Here are a few other common situations where it comes in handy.

Sorting Month Names Correctly (Not Alphabetically)

This is a classic Tableau challenge. If you have a date field like [Order Date] and create a calculated field for the month name (DATENAME('month', [Order Date])), the parameter will list them alphabetically. Not ideal.

The Fix: The process is the same. Create a number-based sort field.

1. Create a calculated field called Month Sort Order with the formula: DATEPART('month', [Order Date]). This will return a number from 1 (for January) to 12 (for December).
2. Right-click your Month Name field, go to Default Properties > Sort, and set it to sort by your Month Sort Order field in ascending order.
3. Create your parameter from the Month Name field. Instant chronological sorting!

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

Handling Dynamic Parameters That Change Over Time

Since Tableau version 2020.1, we have had dynamic parameters, which can update their list of values automatically when your workbook is opened. The great news is that the sorting technique we've covered works perfectly with this feature. When your data is refreshed and new values (e.g., a new project status) are added, the dynamic parameter will automatically add it. And because you’ve defined the sort order on the dimension itself, that new value will appear in the right place (especially if you used the ELSE clause in your CASE statement).

Alternative: Manual Sorting

What if you're connected to a published data source where you can't add calculated fields? You can still sort your parameter, but you have to do it manually.

In the Create Parameter window, instead of clicking Add values from, you can type in each value yourself. Tableau will preserve the exact order in which you enter the items.

• The Upside: It's simple and requires no extra fields.
• The Downside: It's completely static. If a new value is added to your source data, your parameter list won't know about it. You'll have to remember to manually edit the parameter to add it, making this a less-than-ideal solution for data that changes often.

Final Thoughts

Mastering the sorting of parameter values is a small but significant step in creating user-friendly and intuitive Tableau dashboards. By using a dedicated calculated field to define a custom sort order, you gain full control over how your dropdowns are presented, ensuring your audience can find what they're looking for without confusion.

While tweaking configurations and default properties gets the job done in Tableau, we believe getting insights shouldn’t always require learning these kinds of specific workarounds. That's why we built Graphed. Instead of wrestling with calculated fields, you can just connect your sources and ask for what you need in plain English, like "Show me a chart of our monthly sales by project status, sorted logically." Our AI handles all the complex data wrangling and visualization for you, turning hours of tedious setup into a conversation that takes seconds.