Change sort Order with Buttons in Tableau Software – video Skill Pill

Change sort Order with Buttons in Tableau Software

Change sort order with buttons in Tableau Software is helping every end user to easily sort ascending or descending attributes according to different criteria. Watch our video.

In order to create a Highlight on Row and Column in Tableau, please follow these steps:

Step 1: Connect to data

In Tableau Desktop, connect to Superstore sample data provided by Tableau Software.

Step 2: Create the visualization

→ Create a parameter, named Sort Order and select it from Data type as Integer and from Allowable values as List.

→ In the List of values area, for Value type the values 1 and -1 and for Display As type the values Descending and Ascending.

→ Create a calculated field named Descending with the formula: MIN(1).

→ Create a calculated field named Ascending with the formula: MIN(-1).

→ In the Marks area change the display to Shape.

→ Drag the Measure Names field on Rows, on Shape and on Filters.

→ Go to Filters, right click on Measure Names and select Edit Filter. Select only the Ascending and Descending

→ Drag the Measure Values field on Details from Marks

→ Create a new calculated field, named Profit Sort Order with the formula: SUM([Profit])*[Sort Order].

→ Create a new Worksheet and drag the Profit field on Rows and Region field on Columns.

→ Click on Region and select Sort -> Sorty by field. Sort order -> Descending. Field Name -> Profit Sort Order (previously calculated field), Aggregation -> Custom.

→ Create a Dashboard and add a Vertical Container. Add the both sheets, , from Tableau Desktop, business intelligence software.

→ Go to Dashboard -> Actions -> Add action -> Change Parameter. In the Name area select the parameter created for sorting: Sort Order. At Source Sheets check the worksheet in which the parameter is found: Change sort order. Select the Run action on Select. For Target Parameter select Sort Order, for Field select Measure Values (Sample – Superstore) and for Aggregation select Minimum and then click OK.

→ From the sort sheet click on Go to Sheet and on that sheet click on Shape from Marks area and change the shapes for Ascending and Descending.

By Mara Cîșlariu

Download Tableau Software