Filters
Filters limit the data that visuals show. You set them in the Filters pane of the editor. Unlike a slicer, a filter does not take space on the page.
Before you start
Section titled “Before you start”- Open the report in the editor. See Create a report.
- To let viewers filter on the page itself, use a slicer instead. See Slicers.
Filter levels
Section titled “Filter levels”The Filters pane has three sections:
| Section | Filters | Up to |
|---|---|---|
| Filters on this visual | Only the selected visual. Shows only when a visual is selected. | 20 filters |
| Filters on this page | Every visual on the current page. | 50 filters |
| Filters on all pages | Every visual of the report. | 50 filters |
When a section is full, it shows At most N filters at this level.
Add a filter
Section titled “Add a filter”- Click Add filter in a section.
- In Pick a field, pick a column.
You can also:
- Drag a column from the Data pane into a section.
- Right-click a column in the Data pane, then pick Add to filters and This visual, This page or All pages.
Use Search filters at the top of the pane to find a filter card.
Filter types
Section titled “Filter types”Pick a type in Filter type on the filter card. The list shows only the types that fit the field.
| Type | What it does | Fields | Levels |
|---|---|---|---|
| Basic filtering | Tick the values to keep or to drop. | Any | All |
| Advanced filtering | One or two conditions, such as contains or is after. | Any | All |
| Range | Keep values between a minimum and a maximum. | Number, date or time | All |
| Relative date | Keep a period such as the last 3 months. | Date or date-time | All |
| Top N | Keep the top or bottom items by a measure. | Any column | Visual only |
| Value filter | Keep items where a measure meets a condition. | Measure | Visual only |
Basic filtering
Section titled “Basic filtering”- Mode: Include keeps the ticked values. Exclude drops them.
- Require single selection: only one value can be ticked.
- The list shows the first 1,000 values. To find others, use Advanced filtering with contains.
Advanced filtering
Section titled “Advanced filtering”- Under Show items when the value, pick an operator and type a value.
- Optional: pick And or Or, then set the Second condition.
Text operators include is, is not, contains, does not contain, starts with, does not start with, is blank, is not blank, is empty and is not empty. Dates use is on, is before, is after and the like. A value can have up to 200 characters.
Set Minimum, Maximum or both. Include lower bound and Include upper bound choose whether the limits themselves are kept.
Relative date
Section titled “Relative date”Pick Last, This or Next, a Count (1 to 1,000) and a unit: days, weeks, months, quarters or years. Include today keeps today in the period.
- Under Show items, pick Top or Bottom.
- Set the Number of items, from 1 to 10,000.
- Drop a measure in By value.
Value filter
Section titled “Value filter”On the visual level, Add filter also lists Add value filter when the visual groups by a column. Pick a measure, set the condition, then pick the column in Evaluated per.
Manage a filter card
Section titled “Manage a filter card”The icons on a filter card:
| Icon | What it does |
|---|---|
| Rename | Gives the card a name, up to 100 characters. Leave empty to show the field name. |
| Lock filter | Viewers see the filter but cannot change it. |
| Hide in view | Viewers do not see the filter. It still applies. |
| Clear | Clears the condition. The card stays. |
| Remove filter | Removes the card. |
The card arrow collapses or expands it.
What viewers see
Section titled “What viewers see”- In view mode, click Filters. The badge on the button counts the slicer and data point selections on the page.
- The pane lists filters On all pages and On this page.
On a report with slicers, the pane is open when the report opens.
- Hidden filters are not listed.
- Locked filters show Locked.
- Saved filters and slicer selections show as read-only chips. Viewers cannot edit the report’s filter cards.
- A viewer who clicks a data point to cross-filter can remove that filter with Clear this filter.
- Reset to default filters goes back to the filters saved in the report.
To hide the filter button on a single visual, turn off Filter icon in the visual’s Header icons card. See Format and themes.
Frequently asked questions
Section titled “Frequently asked questions”Why can I not pick Top N? Top N and value filters work on the visual level only. Select the visual first.
Why is a value missing from the list? The list shows the first 1,000 values. Use Advanced filtering with contains.
Can viewers change a locked filter? No. They see it but cannot change it.