Slicers

A slicer is a visual on the page that viewers use to filter the other visuals. One slicer type has many styles: a list, a dropdown, buttons, a range slider, a relative date, a date picker or a text box.

Before you start

• Open the report in the editor. See Create a report.
• A slicer filters one column of the data model. Some styles need a number, date or text column (see the table below).

Add a slicer

1. With nothing selected, pick Slicer in Visualizations.
2. Drag a column from the Data pane into Field.
3. Under Slicer style, pick a style.
4. Click Save so viewers get the slicer.

The slicer filters the other visuals of its page. To pick which visuals it filters, use Interactions in the ribbon. See Interactions.

Wells

Well	Takes	Fields
Field	The column to filter	1
Child levels	More columns under the field, as a hierarchy. Vertical list and Dropdown only.	0 to 5
Label	A column shown as a label under each item. List, dropdown, tile and buttons styles.	0 or 1
Highlight label	A measure shown under each item; items where it is blank are dimmed. List, dropdown, tile and buttons styles.	0 or 1

Drop a hierarchy on Field to fill Field and Child levels at once.

Slicer styles

Style	What viewers do	Field type
Vertical list	Tick values in a list.	Any
Dropdown	Open a box and tick values. Picked values show as pills.	Any
Tile	Click values laid out in a row.	Any
Buttons	Click values laid out as a grid of buttons.	Any
Between	Set a lower and an upper bound, with From, To and a range slider.	Number, date or time
Before	Set an upper bound.	Number, date or time
After	Set a lower bound.	Number, date or time
Relative date	Pick a period such as the last 7 days.	Date or date-time
Relative time	Pick a period in minutes or hours.	Date-time
Date picker	Pick a relative period, or a date range or a single date by hand, then click Apply.	Date or date-time
Input	Type values. Each becomes a pill.	Text or number

A style that does not fit the field is grayed out, with the reason, for example Between needs a number, date or time field.

Relative date and relative time

• Pick Last, This or Next, a count (1 to 1,000) and a unit.
• Relative date counts days, weeks, months, quarters or years. A unit with “(calendar)” counts whole calendar periods; without it, the period rolls back from today.
• Relative time counts minutes or hours.
• Include today keeps today in the period.

Periods are worked out in the time zone of the data model.

Date picker

• Relative tab: a period from an Anchor (Today, First date, Last date or Fixed date), with an Offset.
• Manual tab: a date range, or a single date when Single date is on in Slicer settings.
• Click Apply. A warning shows when the range is outside the data.

Input

1. Type a value and press Enter. The value becomes a pill.
2. Double-click a pill to edit it. Click its × to remove it.

For a number field you can type 5, >2, <10 or a range 1-3. A range cannot go with other values. With Accept multiple values on, the slicer takes up to 20 values. Default operator sets how text values match: Contains any, Contains all, Does not contain any, Starts with any, Does not start with any, Is any or Is not any.

Selection options

Select the slicer, open Format, then Slicer settings. The card shows only the options of the current style.

Option	What it does
Selection	Multi-select: each click adds or removes a value. Multi-select with Ctrl: a click replaces the selection, Ctrl+click adds. Single select: one value at a time.
Show “Select all” option	Adds Select all at the top of the list.
Search	Shows the Search values box (Vertical list and Dropdown).
Force selection	Always keeps one value selected.
Show selected first	Lists the selected values first.
Restrict to leaf nodes	With child levels, only the lowest level can be picked.
Single date	The date picker picks one day.
Accept multiple values	The input style takes several values.
Default operator, Operator display	How the input style matches text, and whether it shows an icon or an icon with text.

Search, paste and clear

• Search values finds values in the list. Ctrl+F opens the search box.
• Ctrl+V on a list, dropdown, tile or buttons slicer selects the pasted values: one per line, exact match, up to 2,000 lines. Between hierarchy levels, use tabs.
• Clear filter (the eraser) clears the slicer’s selection.

A list shows the first 1,000 values. Use Search values to find more.

Sync slicers across pages

A synced slicer keeps the same selection on several pages.

1. Select the slicer.
2. Click Sync slicers in the ribbon.
3. For each Page, tick Sync to put a copy of the slicer on that page.
4. Tick Visible to show the copy. Untick it to hide the copy: it still filters that page.
5. Optional: open Advanced options to set a Group name, and to turn Sync field changes to other slicers or Sync filter changes to other slicers on or off.

Every slicer in the same group with the same field gets the same selection, hidden copies too.

Apply all slicers and Clear all slicers

Add buttons so viewers set several slicers, then run the queries once.

1. Click Button in the ribbon.
2. Pick Apply all slicers or Clear all slicers.

With an Apply all slicers button on the page, slicer changes wait. The slicer shows (Not yet applied) and a pending icon until the viewer clicks the button. Clear all slicers clears every slicer on the page.

Note

These buttons work in view mode and in embedded reports. In the editor, clicking them does nothing.

Format a slicer

Slicer format cards in Format, shown for the styles that use them:

Card	Sets
Slicer header	Text (title, font, colors, Show summary), Border, Pending icon
Values	Font, colors, padding, Border, Callout label
Hierarchy	Indentation and the Expand/collapse icon
Selection icon	Show the check marks, and their color
Dropdown	Box border, corners, accent bar, drawer size, pills
Slider	Handle, selected range and track colors
Input box	The look of the input and search boxes
Buttons	Default, Hover, Press and Selected states
Layout	Arrangement, rows and columns, overflow, Shape, Accent bar

See Format and themes for the cards every visual has.

What viewers see

• In view mode, a viewer’s slicer choices apply only to that viewer. They do not change the report.
• The selection you leave in the editor is saved with the report. It is what viewers see first.
• The viewer’s Filters pane lists the slicer selections of the page.
• Bookmarks save slicer selections too.

Frequently asked questions

Why does my slicer not filter another visual? The interaction between them may be off. Check Interactions in the ribbon. A slicer also filters only its own page, unless you sync it to other pages.

Why can I not pick Between? The field is not a number, date or time column.

Why did my selection not apply? The page has an Apply all slicers button. Click it to apply the changes.