Ascending and descending sort in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Sort Order in Tableau

In Tableau, you want to sort a bar chart showing sales by product category in descending order of sales. Which option correctly describes how to apply this sort?

A Click the product category axis, then select Sort > Sort by Field > Sales > Descending.

B Right-click the sales axis and choose Sort > Ascending to sort sales from highest to lowest.

C Drag the sales field to the Filters shelf and select Descending order.

D Use the Analytics pane to drag a Sort object onto the view and select Ascending.

💡 Hint

Think about sorting categories by a measure value, not sorting the axis itself.

In Tableau, sorting categories by a measure is done by clicking the dimension (product category) and choosing Sort by Field with the measure and direction. Option A correctly describes this.

❓ dax_lod_result

intermediate

Sorting Sales by Year in Ascending Order

You have a sales table with a Year column and a Sales Amount column. You want to create a calculated measure in Tableau that returns the total sales sorted by Year ascending. Which Tableau calculation and sort option will achieve this?

A Create a calculated field: SUM([Sales Amount]) and sort Year ascending in the view.

B Create a calculated field: RANK(SUM([Sales Amount])) and sort Year descending.

C Create a calculated field: TOTAL(SUM([Sales Amount])) and sort Year descending.

D Create a calculated field: AVG([Sales Amount]) and sort Year ascending.

💡 Hint

Think about the simplest aggregation and sorting by the Year dimension.

SUM([Sales Amount]) aggregates sales correctly. Sorting the Year dimension ascending will show sales from earliest to latest year. Option A is correct.

❓ visualization

advanced

Identify the Correct Sort Result

You have a bar chart showing sales by region. The regions are sorted descending by sales. Which of the following visualizations correctly represents this sorting?

A Bars arranged randomly with no clear order.

B Bars arranged alphabetically by region name, ignoring sales values.

C Bars arranged from longest to shortest, left to right, with the region having highest sales on the left.

D Bars arranged from shortest to longest, left to right, with the region having highest sales on the right.

💡 Hint

Descending sort means highest values first.

Descending sort by sales means the largest sales bar appears first (left), then smaller bars follow. Option C describes this correctly.

🔧 Formula Fix

advanced

Troubleshoot Incorrect Sort in Tableau

You created a bar chart sorted descending by profit, but the bars appear in ascending order. What is the most likely cause?

A You sorted the dimension by a different measure, like sales, not profit.

B You applied a filter that removed the highest profit values.

C You used a calculated field with an error causing sort to fail.

D You sorted the measure axis instead of the dimension labels.

💡 Hint

Sorting the wrong part of the chart can cause unexpected order.

Sorting the measure axis does not reorder the dimension labels. Sorting must be applied on the dimension to reorder bars. Option D explains this common mistake.

🎯 Scenario

expert

Complex Sorting Scenario with Multiple Dimensions

You have a sales dashboard with two dimensions: Category and Sub-Category. You want to sort Sub-Category descending by total sales within each Category, and Categories ascending alphabetically. Which approach achieves this in Tableau?

A Use a combined calculated field concatenating Category and Sub-Category and sort ascending.

B Sort Category ascending by name, then sort Sub-Category descending by SUM(Sales) using nested sorts on each dimension.

C Sort Sub-Category ascending by name and Category descending by SUM(Sales).

D Sort both Category and Sub-Category descending by SUM(Sales) globally without considering hierarchy.

💡 Hint

Think about sorting each dimension separately respecting hierarchy.

To sort Sub-Category within each Category by sales descending, and Categories alphabetically ascending, you apply separate sorts on each dimension respecting their hierarchy. Option B describes this correctly.

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