Filter views vs filters in Google Sheets - Dashboard Approaches Compared

Dashboard Mode - Filter views vs filters

Goal: Understand the difference between Filter Views and Filters in Google Sheets

This dashboard helps you see how Filter Views and Filters work differently to sort and hide data without changing the original sheet for everyone.

Sample Data: Sales Records

Order ID	Region	Salesperson	Product	Sales Amount
1001	East	Alice	Widget	250
1002	West	Bob	Gadget	300
1003	East	Charlie	Widget	150
1004	South	Diana	Gizmo	400
1005	West	Eva	Widget	350
1006	East	Frank	Gadget	200

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(E2:E7)
  Shows total sales amount from all orders.
• Filter Component: Filter View for East Region
  Creates a filter view named "East Region View" that shows only rows where Region = "East".
  This filter view does not affect what others see.
• Filter Component: Standard Filter for West Region
  Applies a standard filter on the Region column to show only "West" rows.
  This filter changes the sheet view for everyone.
• Table: Filtered Data Using Filter View
  Shows data filtered by the East Region filter view.
  Users can switch to this view without changing the main sheet.
• Table: Filtered Data Using Standard Filter
  Shows data filtered by the standard filter for West Region.
  This changes the sheet for all users until cleared.

Dashboard Layout

+----------------------+--------------------------+
|      Total Sales      |    Filter View: East     |
|      (KPI Card)       |    (Filtered Table)      |
+----------------------+--------------------------+
| Standard Filter: West | Standard Filter: West    |
| (Filter Control)      | (Filtered Table)         |
+----------------------+--------------------------+

Interactivity

The Filter View lets you create and save a filter that only you see. You can switch between views without changing the sheet for others.

The Standard Filter changes the sheet for everyone viewing it. When you apply or clear it, all users see the change.

Clicking on the Filter View or Standard Filter updates the respective filtered tables to show only the selected region's data.

Self Check

If you add a filter view for the South region, which components update?

• The Filter View filtered table updates to show South region data.
• The Standard Filter and its table remain unchanged.
• The Total Sales KPI remains the same because it sums all data.

Key Result

Dashboard showing how Filter Views and Filters work differently to filter sales data by region in Google Sheets.