Skip to content
Tutorials Center
My learning

Topics

Lesson 38 of 56 ยท Visuals and Reports

Filters, Slicers and Sync

Learn the three filter levels, every slicer type, sync slicers across pages, relative date slicers and edit interactions in Power BI, with pandas stand-ins.

A report that shows one fixed view is a poster. A report that lets people narrow it down to their own region, year or product is a tool. Power BI gives you two ways to do the narrowing: filters, which authors usually set up in the Filters pane, and slicers, which are visuals placed on the page that readers click. Both do the same underlying thing: they change the filter context that every measure is evaluated in, exactly as described in CALCULATE and Filter Context.

This lesson explains where each filter lives, which slicer type to use for which kind of field, how to keep slicers in step across pages and how to control what clicking one visual does to the others. The steps are done in Power BI Desktop, so they are described in text. The pandas stand-ins reproduce the logic: how filter levels stack, how highlighting differs from filtering and how a relative date window is calculated.

Filter levels, narrow to wide

Visual Only this one visual.
Page Every visual on this page.
Report Every page in the report.

A visual obeys all three levels at once.

1 / 2

The three filter levels

Open the Filters pane on the right (View > Filters if it is hidden). It has up to three sections:

  • Filters on this visual: affect the selected visual only.
  • Filters on this page: affect every visual on the current page.
  • Filters on all pages: affect every visual in the report (called the report level).

Drag a field into a section to filter by it. Each field gets a filter type:

Filter type What it does Typical use
Basic Tick values from a list Pick regions or categories
Advanced Conditions such as "contains", "is greater than", with AND/OR Name starts with, amount over 1000
Top N Keep the top or bottom N items by a measure Top 10 products by revenue
Relative date A window like the last 30 days Rolling reports
Relative time Hours and minutes before now Operational data

Two details are worth knowing. First, Top N ranks by a value you drag into the "By value" box, and the ranking is calculated with the other filters in force, so a Top 10 on a page filtered to one region is the top 10 in that region. Second, filters can be locked (so a reader cannot change them) or hidden (so they do not appear in the pane when the report is viewed). Use these for filters that define the report, such as "only completed orders", so that readers cannot remove them by accident. Locking is a convenience and not security; for real access control use row-level security (see Row-Level Security).

The stand-in below stacks the same levels in pandas. Each step prints the row count and revenue that remain, and you can see that a visual filter such as Top N applies last, on whatever the other filters left.

Python Filter levels stack up

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Each level removes more rows: 2024 goes at the report level, East at the page level, Cable by the slicer and Lock because only two products survive the Top 2 test. The final chart shows bikes with 1,050 and helmets with 320. In Power BI the filters are combined with AND, so a visual shows only the rows that satisfy every level. That is the reason a visual can be "missing data": check all three levels, plus slicers, before suspecting the measure.

Slicer types

A slicer is a visual that exposes a field's values for readers to pick. Add one by selecting the Slicer visual and dragging a field into it. What it looks like depends on the data type of the field and the Slicer settings under the Format pane (Options):

  • List (vertical or horizontal): tick boxes for a handful of values. Best for fewer than about ten items.
  • Dropdown: the same choices in a compact box, for longer lists.
  • Tile / button: values shown as buttons, nice for years or categories.
  • Between (range slider): for numbers and dates, where readers choose a minimum and maximum.
  • Before / After: a single date or number as a boundary.
  • Relative date: "last 3 months", "this year" and so on, based on today. It needs a date column.
  • Hierarchy slicer: a tree for fields such as Category > Subcategory > Product, with parent selection selecting its children.

Useful settings are Single select (exactly one value, good for a "metric" or a year), Multi-select with Ctrl (the default behavior) and Show "Select all". A slicer search box (the "..." menu) helps with long lists. Slicers only work on fields. You cannot put a measure in a slicer; to let readers choose between measures, use the disconnected-table pattern in Common DAX Patterns.

Keep slicers to a few that matter. Each one is a query, and a page with ten slicers is slower and harder to understand. Put them in a consistent place (a top bar or a left column), and add a Clear all slicers button (covered in Drill-through, Tooltips, Bookmarks and Buttons) so readers can start over.

Relative date slicers

A relative date slicer asks for a window relative to today, so a report always opens on the current period without anyone editing it. Choose Last, This or Next, a number, and a unit. The units come in two flavors that behave differently:

  • Months (calendar): whole calendar months. "Last 3 calendar months" on June 15 is March, April and May.
  • Months: a rolling window counted back from today.

The same applies to weeks and years. Check which flavor you want, because the difference changes the numbers. The slicer needs a real date column, and works best with the marked date table from Date Tables and Time Intelligence Setup. A related option, Include today, adds the current day to the window.

The stand-in fixes "today" at a date so the output never changes, and calculates the "last 3 calendar months" window.

Python A relative date window

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The window runs from March 1 to May 31 and picks up four orders for 440 in total. The two June orders are not included because June is the current, incomplete month, and they belong to "this month", which would show 100. Using whole months is a good way to compare like with like.

Sync slicers

By default a slicer affects only its own page. If readers pick "2025" on page 1 and then open page 2, they expect page 2 to show 2025 too. The Sync slicers pane (View > Sync slicers) lets you do that. For the selected slicer, you see each page with two checkboxes:

  • Sync: the slicer's selection is shared with the same field on that page, even if the slicer is not shown there.
  • Visible: whether the slicer actually appears on that page.

Two common setups: show the slicer on page 1 only and sync it to pages 2 and 3 (invisible but active), or show it on every page and sync them all so the reader can change it anywhere. Slicers are grouped by a group name (under Advanced options) and by field, so two slicers on the same field sync only if they share the group. Keep an eye out for pages where a hidden, synced slicer filters the data without the reader knowing. A small text note ("Showing 2025") avoids confusion.

Edit interactions

When a reader clicks a bar in one chart, the other visuals on the page respond. That is cross-filtering and cross-highlighting, and you control it per pair of visuals. Select the visual that causes the change (the "source"), then choose Format > Edit interactions. Each other visual shows three small icons:

  • Filter: the target is filtered to the selected data.
  • Highlight: the target keeps its full bars and shades the part that belongs to the selection.
  • None: the target ignores the selection.

Highlighting is the default for most charts, and it keeps context visible. Filtering is better for cards and tables, where a shaded part makes no sense. Use None for a visual that should never change, such as a company-wide total card. Slicers always filter, but you can switch a slicer off for a given visual in the same way, which is how you build a page where one chart ignores the year slicer on purpose.

Python Highlight, filter or none

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

With Highlight, the Bike bar stays at 1,350 and 600 of it is shaded. With Filter, the bar becomes 600. With None, nothing changes. The data is the same; the interaction only chooses how the target visual responds to the selection.

Putting it together

A good report page has a few well-chosen slicers (year, region, maybe a category), report-level filters that define scope (for example, completed orders only), page filters for what that page needs, and edit interactions set so that totals and cards behave sensibly. When a number looks wrong, walk through the visual, page and report filters, the slicers and the interactions, in that order. The next lesson shows how readers can go deeper than a filter, with drill-through, tooltips and bookmarks, in Drill-through, Tooltips, Bookmarks and Buttons.

Check your understanding

Quick check ยท 5 questions

of 5 answered You scored / 5 ยท perfect!

  1. 1. A visual shows less data than you expect. Which of these could be filtering it?

    All filter levels and slicers combine with AND, and clicks in other visuals can filter too, so check each of them.
  2. 2. What does Top N in the Filters pane rank by?

    Top N keeps the top or bottom N items according to a value you choose, calculated with the other filters in force.
  3. 3. Which setting makes a slicer's selection apply to other pages?

    The Sync slicers pane shares a slicer's selection with the same field on other pages, whether or not the slicer is visible there.
  4. 4. What is the difference between Highlight and Filter in edit interactions?

    Highlight keeps the overall context visible by shading the selected portion. Filter shows only the selected data.
  5. 5. Which field type makes the Between range slider available?

    Numeric and date fields can use a range slider. Slicers cannot use measures.

Summary

  • Filters work at visual, page and report levels, and combine with AND; the types are basic, advanced, Top N, relative date and relative time.
  • Slicers are visuals for readers: list, dropdown, tile, between, before/after, relative date and hierarchy; they work on fields, not measures.
  • Calendar-based relative windows (whole months) differ from rolling windows; choose deliberately.
  • Sync slicers shares a selection across pages, with separate Sync and Visible options.
  • Edit interactions decide per visual whether a selection filters, highlights or is ignored.

Next: Drill-through, Tooltips, Bookmarks and Buttons.