Tableau Sort

Tableau sort is the process of arranging or ordering the data in Ascending Order or Descending Order. For example, When we are showing products by region report, it would be helpful and practical, if we show the products in any sort manner.

In this article, we will show you How to perform sorting in Tableau reports with example. For this Tableau sort demo, we are going to use the report we created in our previous article.

Tableau Sort Method 1

There are multiple ways to perform sorting in Tableau. From the below screenshot, you can observe that when you hover over the Sales Amount, a tiny little sort button will display near to that. You can use this button to sort the Sales Amount data Ascending or Descending order in Tableau. For now, we selected the Ascending Order.

Tableau Sort 1

Once you click on the Sort button, Color (group) data will be sorted by its sales amount in Ascending Order. Visit Data Labels in Tableau Reports to understand the Tableau Data Source.

Tableau Sort 2

Tableau Sort Method 2

The second method for Tableau sort, Click the Sort button in the Tableau toolbar. From the below screenshot you can observe that when you hover on the Sort button, it will show the tooltip saying that, it’s going to sort the data by Color (group) in Ascending order

Tableau Sort 3

Once you click on the Sort button, Color (group) data will be sorted by its sales amount in Ascending Order as shown below

Tableau Sort 4

To sort Descending order, Click the Sort button in the Tableau toolbar. From the below screenshot you can observe that when you hover on the Sort button, it shows the tooltip saying that, it’s going to sort the data by Color (group) in descending order by its sales amount

Tableau Sort 5

Once you click on the button Color (group) data will be sorted by its sales amount in Descending Order as shown below

Tableau Sort 6

Tableau Sort Method 3

Select and Right Click on the Dimension, on which you want to perform sorting. Please select the Sort.. option from the context menu

Tableau Sort 7

Once you click on the Sort.. option, a new Sort window will be opened to configure the Tableau sorting options. By default, data will sort by the order we specified in the data source. But we can change using the options specified in Sort by section

Tableau Sort 8

If you select the Sort by Field, we have to choose the field name from the drop-down list. Remember if you are viewing Sales amount data in tableau report, you should select the same field here otherwise, sorting results may look strange

Tableau Sort 9

If you choose the Tableau Sort by option Manual, we can manually change the order using Up and down buttons

Tableau Sort 10

For now, we selected the Sort by option as Field and selected Sales Amount in descending order

Tableau Sort 11

Once you click OK button, Color (group) data will be sorted by its sales amount in Descending Order as shown below

Tableau Sort 12

Until now, it looks easy to implement Tableau sort. Because we are performing sort operations on Color (group), which is lying inside the English Country Region Name. Let’s see what will happen if we perform sorting in the Country column. Select and Right Click on the English Country Region name Dimension and select the Sort.. option from the context menu

Tableau Sort 13

Here also, we have chosen the Sort by as Field and selected Sales Amount in descending order

Tableau Sort 14

Once you click the OK button, you may be surprised by the Tableau sort outcome. If you observe the below screenshot, the Country sorted by its sales amount in Descending Order. But you can’t identify it. If you look closely, the United States is in the first place, and the united kingdom is in 3rd place.

Tableau Sort 15

To understand it better, let’s remove the color (group) from the Columns cards, and see the result.

Tableau Sort 16