Dimension filters in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to see sales data filtered by specific product categories and regions to understand performance in targeted areas.

📊 Data: You have sales data including Order ID, Product Category, Region, Sales Amount, and Order Date.

🎯 Deliverable: Create a Tableau dashboard that allows filtering sales by Product Category and Region using dimension filters.

Sample Data

Order ID	Product Category	Region	Sales Amount	Order Date
1001	Electronics	East	1200	2024-01-15
1002	Furniture	West	850	2024-01-18
1003	Clothing	East	400	2024-01-20
1004	Electronics	South	950	2024-01-22
1005	Furniture	North	700	2024-01-25
1006	Clothing	West	300	2024-01-28
1007	Electronics	North	1100	2024-02-01
1008	Furniture	South	650	2024-02-03
1009	Clothing	East	450	2024-02-05
1010	Electronics	West	1300	2024-02-07

1

Step 1: Connect Tableau to the sales data source containing Order ID, Product Category, Region, Sales Amount, and Order Date.

Use Tableau's 'Connect' feature to import the data table.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a new worksheet and drag 'Sales Amount' to Rows and 'Order Date' to Columns to create a sales trend chart.

Rows: SUM(Sales Amount), Columns: Order Date (continuous month/year).

Expected Result

A line chart showing total sales over time appears.

3

Step 3: Add 'Product Category' as a filter by dragging it to the Filters shelf and select all categories initially.

Filters shelf: Product Category (select all).

Expected Result

Filter control for Product Category is created but all categories are selected.

4

Step 4: Add 'Region' as a filter by dragging it to the Filters shelf and select all regions initially.

Filters shelf: Region (select all).

Expected Result

Filter control for Region is created but all regions are selected.

5

Step 5: Show both filters on the worksheet by right-clicking each filter and selecting 'Show Filter'.

Right-click Product Category filter > Show Filter; Right-click Region filter > Show Filter.

Expected Result

Filter panels for Product Category and Region appear on the worksheet for user interaction.

6

Step 6: Test the filters by selecting specific Product Categories and Regions to see the sales trend update accordingly.

Select 'Electronics' and 'Furniture' in Product Category filter; select 'East' and 'West' in Region filter.

Expected Result

The sales trend chart updates to show sales only for Electronics and Furniture in East and West regions.

7

Step 7: Create a dashboard and add the worksheet with filters to it, arranging filters on the side for easy access.

Dashboard layout: Place worksheet center, filters on left side.

Expected Result

Dashboard displays sales trend chart with interactive filters for Product Category and Region.

Final Result

Sales Trend Dashboard

[Product Category Filter]  [Region Filter]

  Sales Amount
    |
1300|      *
    |      *     *
1100|      *     *
    |      *     *
 850|      *  *  *
    |  *   *  *  *
 400|__*___*__*__*___ Order Date
       Jan  Feb

Filters let you pick categories and regions to see sales trends update.

✓Electronics and Furniture have higher sales compared to Clothing.

✓East and West regions show stronger sales performance.

✓Using dimension filters helps focus analysis on specific product categories and regions.

Bonus Challenge

Add a filter for Order Date to allow filtering sales by specific months or date ranges.

Show Hint

Drag 'Order Date' to Filters shelf, choose 'Range of Dates', then show filter on dashboard.

Practice

1. What is the main purpose of a dimension filter in Tableau?

easy

A. To select specific categories or groups of data to include in the view

B. To change the color of the chart

C. To calculate sums and averages

D. To add new data sources

Solution

1. Step 1: Understand what dimension filters do

   Dimension filters let you pick which categories or groups of data to show or hide in your report.

2. Step 2: Compare options to the purpose

   Only To select specific categories or groups of data to include in the view describes selecting categories, which matches the purpose of dimension filters.

3. Final Answer:

   To select specific categories or groups of data to include in the view -> Option A

4. Quick Check:

   Dimension filter = select categories [OK]

Hint: Dimension filters pick categories to show or hide [OK]

Common Mistakes:

• Confusing dimension filters with color formatting
• Thinking filters calculate values
• Mixing up filters with data source connections

2. Which of the following is the correct way to add a dimension filter in Tableau?

easy

A. Drag a measure to the Filters shelf

B. Right-click a measure and select 'Add to Filters'

C. Drag a dimension to the Filters shelf

D. Double-click a dimension to add it to the Columns shelf

Solution

1. Step 1: Identify how to add dimension filters

   Dimension filters are added by dragging a dimension field to the Filters shelf in Tableau.

2. Step 2: Evaluate each option

   Drag a dimension to the Filters shelf correctly states dragging a dimension to the Filters shelf. Drag a measure to the Filters shelf is for measures, not dimensions. Right-click a measure and select 'Add to Filters' is incorrect because measures cannot be added that way as filters. Double-click a dimension to add it to the Columns shelf adds to Columns, not Filters.

3. Final Answer:

   Drag a dimension to the Filters shelf -> Option C

4. Quick Check:

   Dimension filter = drag dimension to Filters shelf [OK]

Hint: Drag dimension fields to Filters shelf to filter categories [OK]

Common Mistakes:

• Dragging measures instead of dimensions
• Adding fields to Columns instead of Filters
• Right-clicking measures expecting filter options

3. If you add a dimension filter on the 'Region' field and select only 'East' and 'West', what will the view show?

medium

A. No data will be shown

B. Data for all regions except 'East' and 'West'

C. Data for 'East', 'West', and 'Central' regions

D. Data only for 'East' and 'West' regions

Solution

1. Step 1: Understand filter selection effect

   Selecting 'East' and 'West' in a dimension filter means only those categories are included in the view.

2. Step 2: Analyze options

   Data only for 'East' and 'West' regions correctly states only 'East' and 'West' data will show. Data for all regions except 'East' and 'West' is the opposite. Data for 'East', 'West', and 'Central' regions adds 'Central' incorrectly. No data will be shown is wrong because data exists for selected regions.

3. Final Answer:

   Data only for 'East' and 'West' regions -> Option D

4. Quick Check:

   Filter selects categories to show = 'East' and 'West' only [OK]

Hint: Filter shows only selected categories, hides others [OK]

Common Mistakes:

• Thinking filter excludes selected categories
• Assuming unselected categories still appear
• Believing filter clears all data

4. You added a dimension filter on 'Category' but the filter does not seem to affect the view. What is the most likely reason?

medium

A. The filter is applied on a measure, not a dimension

B. The filter is set to include all categories

C. The data source is disconnected

D. The filter is applied on a hidden worksheet

Solution

1. Step 1: Identify why a filter might not change the view

   If a filter includes all possible categories, it does not remove any data, so the view stays the same.

2. Step 2: Evaluate each option

   The filter is set to include all categories correctly explains the filter includes all categories, so no change. The filter is applied on a measure, not a dimension is incorrect because the question says dimension filter was added. The data source is disconnected would cause errors, not no effect. The filter is applied on a hidden worksheet is unlikely to affect the current view.

3. Final Answer:

   The filter is set to include all categories -> Option B

4. Quick Check:

   Filter includes all categories = no effect [OK]

Hint: Check if filter includes all categories to see effect [OK]

Common Mistakes:

• Assuming filter always changes view
• Ignoring filter settings include all values
• Confusing data source issues with filter behavior

5. You want to create a dashboard showing sales only for selected product categories and regions. Which approach correctly uses dimension filters to achieve this?

hard

A. Add separate dimension filters for 'Category' and 'Region' on the dashboard and select desired values

B. Add a measure filter on sales amount and ignore categories and regions

C. Use only one dimension filter on 'Category' and leave 'Region' unfiltered

D. Create a calculated field combining 'Category' and 'Region' and filter on that

Solution

1. Step 1: Understand filtering multiple dimensions

   To filter by both product category and region, you need filters on both dimensions separately.

2. Step 2: Evaluate options for filtering both dimensions

   Add separate dimension filters for 'Category' and 'Region' on the dashboard and select desired values correctly adds separate filters for 'Category' and 'Region'. Add a measure filter on sales amount and ignore categories and regions filters only sales amount, not categories or regions. Use only one dimension filter on 'Category' and leave 'Region' unfiltered filters only one dimension, missing the other. Create a calculated field combining 'Category' and 'Region' and filter on that is complex and unnecessary for this task.

3. Final Answer:

   Add separate dimension filters for 'Category' and 'Region' on the dashboard and select desired values -> Option A

4. Quick Check:

   Filter each dimension separately for combined filtering [OK]

Hint: Use separate filters for each dimension to combine selections [OK]

Common Mistakes:

• Filtering only one dimension when multiple needed
• Using measure filters instead of dimension filters
• Overcomplicating with calculated fields unnecessarily