Dashboard Mode - Parameter controls
Business Question
How can we use a parameter control to dynamically change the sales target and see which products meet or exceed this target?
0
0
Parameter controls in Tableau - Dashboard Guide
Sample Data
| Product | Category | Sales |
|---|---|---|
| Chair | Furniture | 250 |
| Desk | Furniture | 450 |
| Pen | Office Supplies | 150 |
| Notebook | Office Supplies | 300 |
| Phone | Technology | 600 |
| Monitor | Technology | 400 |
Dashboard Components
- KPI Card: Total Sales
Formula: SUM([Sales])
Result: 2150 - Parameter Control: Sales Target
Type: Integer slider from 100 to 700, default 400 - Calculated Field: Meets Target
Formula: IF [Sales] >= [Sales Target] THEN "Yes" ELSE "No" END - Bar Chart: Sales by Product
Color: Green if Meets Target = 'Yes', Red if 'No'
Shows each product's sales with color indicating if it meets the target - Table: Product Sales and Target Status
Columns: Product, Sales, Meets Target
Dashboard Layout
+----------------------+-----------------------+ | KPI Card | Parameter Control | | Total Sales: 2150 | Sales Target Slider | +----------------------+-----------------------+ | Bar Chart: Sales by Product | | (Colored bars showing if sales meet target) | +------------------------------------------------+ | Table: Product Sales and Target Status | +------------------------------------------------+
Interactivity
The Sales Target parameter control lets the user pick a sales target number.
The Meets Target calculated field uses this parameter to check each product's sales.
The Bar Chart colors bars green or red based on whether sales meet the target.
The Table updates to show which products meet or do not meet the selected sales target.
Self Check
If you change the Sales Target parameter to 500, which products will show as meeting the target?
Answer: Only Phone with sales 600 meets the target; others show 'No'.
Key Result
Dashboard showing total sales and dynamically highlighting products meeting a user-selected sales target using a parameter control.