Why parameters add user-driven flexibility in Tableau - Dashboard Impact

Dashboard Mode - Why parameters add user-driven flexibility

Business Question

How can parameters let users change dashboard views and explore data their way?

Sample Data: Sales by Region and Category

Region	Category	Sales	Profit
East	Furniture	1000	200
East	Technology	1500	300
West	Furniture	1200	250
West	Technology	1700	400
Central	Furniture	900	180
Central	Technology	1300	350

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 7600
• KPI Card: Total Profit
  Formula: SUM([Profit])
  Result: 1680
• Bar Chart: Sales by Region
  Formula: SUM([Sales]) grouped by [Region]
  Values: East=2500, West=2900, Central=2200
• Parameter: Choose Metric
  Options: Sales, Profit
  Used to switch bar chart metric dynamically
• Bar Chart with Parameter: Metric by Region
  Formula: IF [Choose Metric] = 'Sales' THEN SUM([Sales]) ELSE SUM([Profit]) END
  Shows sales or profit by region based on user choice

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |     Total Profit      |
|       (KPI Card)      |      (KPI Card)       |
+----------------------+----------------------+
|                                              |
|           Metric by Region Bar Chart          |
|          (Changes by parameter choice)       |
|                                              |
+----------------------------------------------+
|               Choose Metric Parameter         |
+----------------------------------------------+

Interactivity

The Choose Metric parameter lets users pick either Sales or Profit. When changed, the bar chart updates to show the selected metric by region. This gives users control to explore different views without needing multiple charts.

Self Check

If you change the Choose Metric parameter to Profit, which components update?

• The Metric by Region Bar Chart updates to show profit values instead of sales.
• The KPI cards remain the same because they show totals for both metrics.

Key Result

Dashboard shows total sales and profit KPIs with a bar chart that switches between sales and profit by region using a user-driven parameter.