Measure filters in Tableau - Dashboard Guide

Dashboard Mode - Measure filters

Dashboard Goal

Find out which products have sales above a chosen amount and see their sales and profit details.

Sample Data

Product	Category	Sales	Profit
Chair	Furniture	250	50
Desk	Furniture	400	120
Pen	Office Supplies	150	30
Notebook	Office Supplies	100	20
Monitor	Technology	600	200
Keyboard	Technology	300	80

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 1800
• KPI Card: Total Profit
  Formula: SUM([Profit])
  Result: 500
• Bar Chart: Sales by Product
  Shows sales amount for each product.
  Data: Products on X-axis, Sales on Y-axis.
• Bar Chart: Profit by Product
  Shows profit amount for each product.
  Data: Products on X-axis, Profit on Y-axis.
• Measure Filter: Sales Threshold Filter
  Filter condition: [Sales] >= [Selected Sales Threshold]
  Allows user to select a minimum sales value to filter products shown in charts.

Dashboard Layout

+----------------------+----------------------+
|   Total Sales (KPI)  |   Total Profit (KPI)  |
+----------------------+----------------------+
|                                              |
|          Sales by Product (Bar Chart)         |
|                                              |
+----------------------------------------------+
|                                              |
|         Profit by Product (Bar Chart)         |
|                                              |
+----------------------------------------------+
|  Sales Threshold Filter (Slider)              |
+----------------------------------------------+

Interactivity

The Sales Threshold Filter is a slider control where the user picks a minimum sales value.

When the user changes this filter, both bar charts update to show only products with sales equal or above the selected value.

The KPI cards show totals for all products regardless of the filter.

Self Check

If you set the Sales Threshold Filter to 300, which products appear in the charts?

Answer: Desk (400), Monitor (600), Keyboard (300) appear. Chair (250), Pen (150), Notebook (100) are filtered out.

Key Result

Dashboard shows total sales and profit KPIs plus sales and profit by product filtered by a sales threshold slider.