Skip to main content

Locked Filters

Locked Filters let you fix important filters in place so viewers can explore data safely without changing key context.

Piers Batchelor avatar
Written by Piers Batchelor
Updated over a week ago

Locked Filters give report designers more control over how people use dashboards. They let you fix important filters in place so viewers can explore data safely without changing key context.

Think of it as guardrails for analytics. You decide which fields must stay fixed and which ones users can play with.

This feature is built for two main needs: visual data reduction and guided experiences.

Locked Filters help you deliver dashboards that are:

  • safer

  • easier to use

  • more reliable

  • better governed

  • more guided

They give designers confidence and users clarity.

Whether you are protecting customer data or building app-style analytics, Locked Filters make it simple.


Why Locked Filters Matter

In real business dashboards, not every filter should be open to change.

Sometimes you need to protect sensitive scope, like:

  • a customer account

  • a region

  • a reporting period

  • a department

  • a secure data segment

Other times you want to lead users through a specific flow where filters are set for them and should not be touched.

Locked Filters solve both problems in a simple, visual way.


Use Cases

Hide Sensitive Data

Create/Template Guided Dashboards

Support Confident Self-Serve Analytics

You may have dashboards shared across teams, but each team benefits only from their own data.
By locking filters like “Customer” or “Region,” you stop users from accidentally (or intentionally) switching to other datasets.

Many dashboards act like apps. Users click buttons to move through steps.
Those buttons can set filters and lock them automatically.

Example
A navigation button sets “Region = EMEA” and “Year = 2025” and locks both.

Create one dashboard template and reuse it for many customers or departments.Lock the core filters for each version so viewers only see what matters to them.

Some filters are critical to calculations. If a user clears them, charts can go blank or return confusing results. Locking those fields keeps reports stable and reliable. Users still get freedom to explore, but only where it makes sense. You can lock the foundation and leave optional filters open.

How It Works

  • Filter locking is enabled at the workbook level by a workbook editor.

  • When enabled, filters in the filter bar show a small lock icon.

  • Users with permissions can lock or unlock specific filters.

  • A locked filter cannot be changed until it is unlocked.

  • “Clear All” ignores locked filters so key values are never removed.

Locks can be applied in two ways:

Manual locking
A user clicks the lock icon on a filter to protect its current value.

Action-based locking
Buttons or automation can lock filters as part of a workflow.


Key Behavior Rules

  • Bookmarks can override locks when applied. ⚠️

  • Other actions can still update a locked filter if designed to do so. ⚠️

  • A filter can be locked even if it has no value selected.

  • If a filter is locked while it has pending changes, those changes are removed.

  • Locked filters do not show possible values to viewers – only applied ones.

  • Locked filters are skipped when someone clicks “Clear All.”

This keeps things predictable while still allowing advanced guided setups.

Permissions

Control is simple:

  • Workbook owners and editors can manage filter locks by default.

  • Viewers normally cannot change lock states.

  • A permission option “Can manage filter locks” controls who is allowed.

Hidden filters can also be locked. Viewers never see them, but designers can manage them.

Working with Actions

Designers can use new actions:

  • Lock Filter – locks a specific field

  • Unlock Filter – removes a lock

  • Toggle Filter Lock – flips the current state

ℹ️ A toast popup message can be presented, informating the user that a field lock state has been changed.

Actions can also:

  • set a value and lock it in one step

  • show a toast message like “Region was locked”

This is perfect for buttons such as:

  • “View Finance Only”

  • “Lock to My Accounts”

  • “Reset Guided Flow”

What Users See

When a filter is locked:

  • the dropdown cannot be edited

  • only the current value is visible

  • no new values are loaded or queried

  • a clear lock icon shows its status

If the user has rights, they can unlock it and take back control.

Did this answer your question?