Tableau Sort

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

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

Tableau Sort Method

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 button will display near that. You can use this button to sort the Sales Amount data in Ascending or Descending orders. For now, we selected the Ascending Order.

Tableau Sort in Y Axis 1

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

Measure Field Order By Ascending 2

Tableau Sort Method 2

In the second method, click the Sort button in the toolbar. As you can see, when you hover on the button, it will show the tooltip saying that it’s going to order the data by Color (group) in Ascending by SalesAmount

Tableau Sort using Toolbar Button 3

Once you click on the button, Color (group) data will be ordered by its sales amount in Ascending.

Ascending 4

For the Descending order, Click the next sort button in the toolbar. From the screenshot below, you can observe that when you hover on it, it shows the tooltip saying that it will sort the data by Color (group) in descending by its sales amount.

Tableau Sort order by descending 5

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

descending order 6

Method 3

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

Tableau Sort using Column and Rows Shelfs fields 7

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

Sort Windows Options 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 a report, you should select the same field here otherwise, the results may look strange.

Choose the Field and Order type 9

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

Up and Down options 10

For now, we selected the option as Field and selected Sales Amount in descending.

Choose the Aggregation and click ok 11

Once you click the OK button, sort the Color (group) data and order by its sales amount in Descending.

Chart in Descending Order 12

Until now, it looks easy to implement it. 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 on 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 by multiple columns 13

Here also, we have chosen the option as Tableau sort Field and selected Sales Amount in descending order.

Choose the Field for Descending Order 14

Once you click the OK button, you may be surprised by the outcome. If you observe the below screenshot, the Country is ordered by its sales amount in Descending. 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 sorting better, let’s remove the color (group) from the Columns cards and see the result.

Tableau Sort 16