Ascending and descending sort in Tableau - Step-by-Step Guide

Introduction

Sorting data in ascending or descending order helps you see your data from smallest to largest or largest to smallest. This makes it easier to find top or bottom values quickly in your Tableau visualizations.

When you want to see sales figures from lowest to highest to identify underperforming products

When you need to list customers by highest purchase amount to find your best clients

When you want to organize dates from earliest to latest in a timeline chart

When you want to rank regions by descending profit to focus on top-performing areas

When you want to sort categories alphabetically to find a specific item quickly

Steps

Step 1: Open your Tableau worksheet

- Tableau workspace

Your current visualization is visible with data fields and marks

💡 Make sure your data is loaded and visible in the view

Step 2: Locate the field you want to sort in the Columns or Rows shelf

- Columns or Rows shelf

The field is highlighted and ready for sorting

💡 You can also sort directly from the axis or header in the view

Step 3: Click the sort icon (up or down arrow) next to the field name on the shelf or axis

- Field header on Columns/Rows shelf or axis label in the view

Data is sorted in ascending order if you clicked the up arrow, or descending if you clicked the down arrow

💡 Clicking the icon again toggles between ascending and descending

Step 4: Alternatively, right-click the field in the view and select 'Sort...'

- Field in the view

Sort dialog box opens with sorting options

💡 Use this to customize sorting by field, manual order, or nested sorting

Step 5: Choose 'Ascending' or 'Descending' in the Sort dialog and click OK

- Sort dialog box

The visualization updates to reflect the chosen sort order

💡 You can also sort by a specific measure or field here

Before vs After

Before

Bar chart shows product categories in random order: Chairs, Tables, Lamps, Sofas

After

Bar chart shows product categories sorted descending by sales: Sofas, Tables, Chairs, Lamps

Settings Reference

Sort Order

📍 Sort dialog box accessed by right-clicking a field and selecting 'Sort...'

Determines whether data is sorted from smallest to largest or largest to smallest

Default: Ascending

Sort By

📍 Sort dialog box

Defines the basis for sorting the data

Default: Data Source Order

Sort Field

📍 Sort dialog box when 'Field' is selected under Sort By

Specifies which field to use for sorting when sorting by field

Default: None

Common Mistakes

Clicking the sort icon on the wrong field

Sorting the wrong field changes the order unexpectedly and confuses the visualization

Always confirm you are sorting the correct field on the Columns or Rows shelf or axis

Using manual sort without understanding the order

Manual sort can override automatic sorting and cause unexpected order

Use manual sort only when you want a custom order; otherwise, use ascending or descending

Summary

Sorting in Tableau lets you order data from smallest to largest or largest to smallest.

You can sort by clicking the sort icon or using the Sort dialog for more options.

Always check you are sorting the correct field to avoid confusing results.

Practice

1. In Tableau, what does sorting data in ascending order do?

easy

A. It arranges data from smallest to largest values.

B. It arranges data from largest to smallest values.

C. It groups data by categories alphabetically.

D. It filters out duplicate data points.

Solution

1. Step 1: Understand ascending sort meaning

   Ascending order means arranging values starting from the smallest and going to the largest.

2. Step 2: Apply to Tableau sorting

   In Tableau, sorting ascending will show data from smallest to largest values.

3. Final Answer:

   It arranges data from smallest to largest values. -> Option A

4. Quick Check:

   Ascending = smallest to largest [OK]

Hint: Ascending means smallest to largest values [OK]

Common Mistakes:

• Confusing ascending with descending order
• Thinking sorting filters data
• Assuming sorting groups data instead

2. Which of the following is the correct way to sort a field in descending order in Tableau?

easy

A. Click the field header once to toggle descending sort.

B. Use the Sort menu and choose 'Descending'.

C. Right-click the field header and select 'Sort Ascending'.

D. Drag the field to the Filters shelf.

Solution

1. Step 1: Identify sorting options in Tableau

   Tableau allows sorting via the Sort menu where you can explicitly choose ascending or descending.

2. Step 2: Confirm descending sort method

   Choosing 'Descending' in the Sort menu correctly sorts data from largest to smallest.

3. Final Answer:

   Use the Sort menu and choose 'Descending'. -> Option B

4. Quick Check:

   Sort menu + Descending = correct method [OK]

Hint: Use Sort menu for clear ascending/descending choice [OK]

Common Mistakes:

• Clicking field header once only sorts ascending
• Dragging fields to Filters shelf does not sort
• Selecting 'Sort Ascending' sorts opposite order

3. Given a Tableau bar chart sorted descending by Sales, what will be the order of bars if Sales values are: 100, 250, 50, 300?

medium

A. 300, 250, 100, 50

B. 250, 300, 100, 50

C. 100, 50, 250, 300

D. 50, 100, 250, 300

Solution

1. Step 1: Understand descending sort order

   Descending order arranges values from largest to smallest.

2. Step 2: Sort given Sales values descending

   Values sorted descending: 300, 250, 100, 50.

3. Final Answer:

   300, 250, 100, 50 -> Option A

4. Quick Check:

   Descending sort = largest to smallest [OK]

Hint: Descending means largest value first [OK]

Common Mistakes:

• Sorting ascending instead of descending
• Mixing up order of values
• Assuming default order is alphabetical

4. You tried to sort a dimension in Tableau descending but the data still appears ascending. What is the likely cause?

medium

A. Tableau does not support descending sort on dimensions.

B. The data source is corrupted and cannot sort.

C. You applied sorting on a measure instead of a dimension.

D. You clicked 'Sort Ascending' instead of 'Sort Descending'.

Solution

1. Step 1: Check sorting action performed

   Clicking 'Sort Ascending' will keep data in ascending order, not descending.

2. Step 2: Verify Tableau sorting capabilities

   Tableau supports descending sort on dimensions; data source corruption is unlikely cause.

3. Final Answer:

   You clicked 'Sort Ascending' instead of 'Sort Descending'. -> Option D

4. Quick Check:

   Wrong sort direction clicked = ascending shown [OK]

Hint: Double-check sort direction clicked in Tableau [OK]

Common Mistakes:

• Assuming Tableau can't sort dimensions descending
• Blaming data source without checking sort settings
• Sorting measure instead of dimension by mistake

5. You have a sales report with Product Categories and Sales. You want to show the top 3 categories by sales in descending order. Which steps should you follow in Tableau?

hard

A. Sort Product Categories ascending by Sales, then filter top 3.

B. Sort Product Categories descending by Sales, then filter top 3.

C. Filter top 3 Product Categories by Sales, then sort descending by Sales.

D. Filter top 3 Product Categories by Sales, then sort ascending by Sales.

Solution

1. Step 1: Filter top 3 Product Categories by Sales

   Apply a filter to keep only the top 3 categories based on Sales values.

2. Step 2: Sort the filtered categories descending by Sales

   Sort these top 3 categories so the highest sales appear first.

3. Final Answer:

   Filter top 3 Product Categories by Sales, then sort descending by Sales. -> Option C

4. Quick Check:

   Filter top 3 first, then descending sort [OK]

Hint: Filter top 3 first, then sort descending [OK]

Common Mistakes:

• Sorting before filtering top 3
• Sorting ascending instead of descending
• Filtering after sorting ascending