Manual sort order in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Manual Sort Order in Tableau

In Tableau, you want to display product categories in a specific order: Electronics, Furniture, Office Supplies. Which method correctly applies a manual sort order?

A Use the default sort option which sorts categories by sales descending automatically.

B Create a calculated field with alphabetical sorting and use it as the sort order.

C Drag and drop categories in the desired order directly on the axis or header in the view.

D Apply a filter to show only the categories in the desired order.

💡 Hint

Think about how Tableau allows you to reorder items visually without changing data.

Manual sort order in Tableau is done by dragging and dropping items directly in the view to reorder them as you want. This overrides automatic sorting.

❓ dax_lod_result

intermediate

Manual Sort Order Using a Sort Index

You have a table with product categories and a custom sort index column to define manual order. Which DAX expression correctly returns the categories sorted by this manual order?

Categories = 
  DATATABLE(
    "Category", STRING, {"Electronics", "Furniture", "Office Supplies"},
    "SortIndex", INTEGER, {1, 2, 3}
  )

A SORTBYCOLUMNS(Categories, Categories[SortIndex], ASC)

B ORDERBY(Categories, Categories[Category], ASC)

C FILTER(Categories, Categories[SortIndex] > 0)

D TOPN(3, Categories, Categories[Category], ASC)

💡 Hint

Look for the function that sorts by a specific column in ascending order.

SORTBYCOLUMNS sorts the table by the SortIndex column, which defines the manual order.

❓ visualization

advanced

Visualizing Manual Sort Order in Tableau

You created a manual sort order for regions: East, West, North, South. Which visualization best shows the manual order applied correctly?

A A scatter plot with regions randomly ordered.

B A pie chart with regions sorted alphabetically.

C A line chart with regions sorted by total sales descending.

D A bar chart with regions ordered East, West, North, South on the axis.

💡 Hint

Manual sort order affects the axis order in charts like bar charts.

Bar charts show categories on an axis, so manual sorting is visible as the order of bars.

🔧 Formula Fix

advanced

Debugging Manual Sort Order Not Applying

You manually reordered categories in Tableau, but the view still shows alphabetical order. What is the most likely cause?

A The data source is missing the categories column.

B The field is sorted by a measure or another field overriding manual sort.

C The workbook is in read-only mode preventing sorting.

D The filter is excluding all categories.

💡 Hint

Think about what can override manual sorting in Tableau.

If a field is sorted by a measure or another field, manual drag-and-drop sorting is overridden and not applied.

🎯 Scenario

expert

Implementing Manual Sort Order with Multiple Dimensions

You have two dimensions: Category and Region. You want to manually sort categories as Electronics, Furniture, Office Supplies and regions as East, West, North, South. How do you implement manual sort order for both dimensions simultaneously in Tableau?

A Manually drag and drop categories and regions separately in their respective shelves or axes to set order.

B Apply a filter to show only the desired categories and regions in default order.

C Create a combined calculated field concatenating category and region and sort alphabetically.

D Use a parameter to switch between sorting by category or region.

💡 Hint

Manual sorting works independently on each dimension in Tableau.

You must manually reorder each dimension separately by dragging items in their respective shelves or axes to apply manual sort order for both.