Field sort (alphabetic, data source) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Default Field Sorting in Tableau

In Tableau, when you add a dimension to the Rows shelf, how is it sorted by default?

A By the order of data appearance in the data source

B Alphabetically ascending

C By measure values in descending order

D Randomly each time the view refreshes

💡 Hint

Think about how Tableau respects the original data unless you specify otherwise.

By default, Tableau sorts dimension members in the order they appear in the data source, not alphabetically.

❓ dax_lod_result

intermediate

Sorting a Field Alphabetically in Tableau

You want to sort the 'Category' dimension alphabetically ascending in Tableau. Which method will achieve this?

A Right-click 'Category' > Sort > Sort by 'Data Source Order'

B Right-click 'Category' > Sort > Sort by 'Alphabetic' ascending

C Drag 'Category' to Columns and sort by measure

D Create a calculated field with RANK() and sort by it

💡 Hint

Look for the option that explicitly sorts alphabetically.

Choosing 'Sort by Alphabetic' ascending sorts the field alphabetically from A to Z.

❓ visualization

advanced

Visualizing the Effect of Data Source Order Sort

You have a 'Region' dimension with values in this order in your data source: East, West, North, South. You want to create a bar chart sorted by this data source order. Which Tableau setting ensures the bars appear in this exact order?

A Sort 'Region' by 'Data Source Order' ascending

B Sort 'Region' by 'Alphabetic' ascending

C Sort 'Region' by 'Field' descending using Sales measure

D Sort 'Region' manually by dragging bars in the view

💡 Hint

Think about preserving the original order from the data source.

Sorting by 'Data Source Order' keeps the dimension members in the order they appear in the source data.

🔧 Formula Fix

advanced

Troubleshooting Unexpected Sort Order in Tableau

You set a dimension 'Product' to sort alphabetically ascending, but the view still shows a different order. What is the most likely cause?

A Tableau does not support alphabetic sorting on dimensions

B The data source order always overrides any sort settings

C The measure used in the view forces a descending sort

D A manual sort was applied previously and overrides the alphabetic sort

💡 Hint

Consider if any manual user actions might override automatic sorting.

Manual sorts take precedence over automatic sorts like alphabetic or data source order.

🎯 Scenario

expert

Combining Data Source and Alphabetic Sorting in a Complex Tableau Dashboard

You have a dashboard with multiple sheets using the 'Category' dimension. Some sheets require sorting by data source order, others alphabetically. How can you manage sorting to meet both needs without duplicating the data source?

A Duplicate the data source and set different sort orders in each

B Change the data source order to alphabetic and use it everywhere

C Create two separate calculated fields for 'Category' with different sort orders and use them accordingly

D Use a parameter to toggle sorting mode globally for all sheets

💡 Hint

Think about how Tableau allows different fields with different properties.

Creating separate calculated fields lets you assign different sorts without changing the original data source or duplicating it.