Why filtering focuses analysis in Tableau - Dashboard Impact

Dashboard Mode - Why filtering focuses analysis

Business Question

How does filtering data help us focus on specific parts of sales to understand performance better?

Sample Data

Region	Product	Sales	Month
East	Widget	100	Jan
East	Gadget	150	Jan
West	Widget	200	Jan
West	Gadget	250	Jan
East	Widget	120	Feb
East	Gadget	180	Feb
West	Widget	220	Feb
West	Gadget	270	Feb

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Shows total sales for the selected data.
• Bar Chart: Sales by Region
  Shows sales totals for East and West regions.
  Formula: SUM([Sales]) grouped by [Region].
• Bar Chart: Sales by Product
  Shows sales totals for Widget and Gadget.
  Formula: SUM([Sales]) grouped by [Product].
• Filter: Region
  Allows selecting one or both regions to focus analysis.
• Filter: Month
  Allows selecting one or more months to narrow the time period.

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |   Filter: Region     |
|      (KPI Card)       |                      |
+----------------------+----------------------+
|  Bar Chart: Sales by Region           |
+--------------------------------------+ 
|  Bar Chart: Sales by Product          |
+--------------------------------------+ 
|           Filter: Month               |
+--------------------------------------+ 

Interactivity

The Region filter controls which regions appear in the KPI card and both bar charts. Selecting only 'East' will update all visuals to show data only for East region.

The Month filter controls the time period shown. Selecting 'Jan' will update all visuals to show sales only for January.

Filters work together to let you focus on specific slices of data, making it easier to understand sales performance in detail.

Self Check

If you apply a filter to show only the 'West' region, which components update?

• The Total Sales KPI updates to show sales only for West.
• Both Bar Charts update to show sales data only for West region.
• The Filters remain available to adjust further.

Key Result

A sales dashboard showing total sales and sales by region and product, demonstrating how filtering by region and month focuses analysis.