Why sorting organizes visual display in Tableau - Dashboard Impact

Dashboard Mode - Why sorting organizes visual display

Business Question

How can sorting data in Tableau help us better understand sales performance by organizing the visual display?

Sample Data

Product	Region	Sales
Chair	East	300
Table	West	450
Lamp	East	150
Sofa	South	500
Desk	West	400
Bookshelf	South	350

Dashboard Components

• KPI Card: Total Sales calculated as SUM([Sales]) = 2150
• Bar Chart: Sales by Product sorted descending by Sales value. This uses Tableau's sort feature on the Sales axis to order bars from highest to lowest sales.
• Table: Shows Product, Region, and Sales with sorting enabled on the Sales column descending to match the bar chart order.

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |      Bar Chart       |
|   Total Sales: 2150  | Sales by Product     |
+----------------------+----------------------+
|                      Table (Product, Region, Sales)             |
+---------------------------------------------------------------+

Interactivity

Sorting the bar chart by Sales automatically updates the table sorting to keep the order consistent. Selecting a product in the bar chart highlights the corresponding row in the table. Filters on Region update both the bar chart and table to show only selected regions, maintaining the sorted order.

Self Check

If you add a filter for Region = West, which components update and how?

• The bar chart updates to show only Table and Desk products sorted by sales.
• The table updates to show only rows with Region West, sorted descending by Sales.
• The KPI card updates to show total sales for West region only (850).

Key Result

A Tableau dashboard showing total sales, a bar chart sorted by sales descending, and a matching sorted table to organize visual display for better sales insights.