Dashboard Mode - Manual sort order
Dashboard Goal
Show sales performance by product category sorted in a custom order that matches business priorities, not alphabetical or numeric order.
0
0
Manual sort order in Tableau - Dashboard Guide
Sample Data
| Category | Sales |
|---|---|
| Accessories | 1500 |
| Clothing | 3000 |
| Furniture | 2500 |
| Technology | 4000 |
| Office Supplies | 1000 |
Dashboard Components
- KPI Card: Total Sales
Formula:SUM([Sales])
Result: 12000 - Bar Chart: Sales by Category with Manual Sort
Manual Sort Order: Technology (1), Furniture (2), Clothing (3), Accessories (4), Office Supplies (5)
Explanation: Categories are sorted by business priority, not alphabetically. - Table: Sales by Category
Shows raw sales numbers for each category.
Dashboard Layout
+----------------------+-----------------------+
| Total Sales | Sales by Category |
| (KPI Card) | (Bar Chart) |
+----------------------+-----------------------+
| Sales by Category Table |
+---------------------------------------------------------+
Interactivity
A category filter allows users to select one or more categories. When filtered, the bar chart and table update to show only selected categories, maintaining the manual sort order. The total sales KPI updates to sum sales of the filtered categories.
Self Check
Add a filter to show only Technology and Furniture categories. Which components update and what do they show?
- Total Sales KPI: Updates to 6500 (4000 + 2500)
- Bar Chart: Shows bars for Technology and Furniture only, in that manual order.
- Table: Shows sales rows for Technology and Furniture only.
Key Result
Dashboard showing sales by product category sorted in a custom manual order with interactive filtering.