What Does the Slicer Icon Look Like in Power BI?

Trying to filter your data in a Power BI report but can't quite remember what the slicer icon looks like? You're in the right place. This guide will show you exactly what to look for, where to find it in the interface, and how to use slicers to make your reports interactive and user-friendly.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Where to Find the Slicer Icon in Power BI?

You can find the Power BI slicer icon in the Visualizations pane, which is typically located on the right side of the Power BI Desktop window. It's one of the standard, out-of-the-box visuals available for every report you create.

The icon itself looks like a funnel with several horizontal lines to its right. This imagery is meant to represent filtering down your data. Here is what you should be looking for:

Once you click this icon, an empty slicer placeholder will appear on your report canvas, ready for you to add data to it. If you can't see it immediately, you might just need to scroll down a bit within the Visualizations pane to find it.

A Step-by-Step Guide to Adding a Slicer to Your Report

Identifying the icon is the first step. Now, let's walk through how to add a functional slicer to your report canvas and connect it to your data.

Step 1: Make Sure Your Report is Open

Start with Power BI Desktop open and the report you want to edit loaded on the screen. Ensure there is no specific visual selected on your canvas by clicking on some blank space.

Step 2: Locate the Visualizations Pane

Look to the right side of your screen. You should see the Visualizations and Data panes. The Visualizations pane is where the collection of icons for charts, tables, and slicers is located. If the pane is collapsed, just click on its header to expand it.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Click the Slicer Icon

Click once on the slicer icon we identified earlier. Power BI will immediately add an unconfigured slicer visual to your active report page. You can drag this empty box around and resize it just like any other report element.

Step 4: Drag a Field Onto the Slicer

With the new slicer selected, your next step is to tell it which data to filter. Go to the Data pane (usually to the far right), find the table and data field you want to use as a filter, and drag it into the "Field" box in the Visualizations pane.

Common fields to use for slicers include:

• Categorical Data: Product Category, Country, Sales Rep, Department.
• Dates: Order Date, Sign-up Date, Invoice Date.
• Numbers: Price, Age, Quantity. While possible, filtering by specific numbers is often better suited for numeric range slicers, which we'll cover next.

As soon as you drop the field into the slicer, it will populate with the unique values from that data column, allowing you or your end-users to start filtering your report visuals.

Customizing Your Slicer: Going Beyond the Basics

A default slicer is useful, but Power BI gives you powerful options to control its appearance and behavior. Let's look at the most common customizations you might want to make.

To access these settings, select your slicer on the canvas and click the "Format your visual" icon, which looks like a paintbrush.

Changing the Slicer Type: List, Dropdown, and Buttons

One of the most useful changes you can make is altering how the slicer options are presented. Under "Format your visual," navigate to Slicer settings > Options > Style. Your main choices are:

• Vertical List: This is the default. It's great when you have only a handful of options that you want to be permanently visible on the report.
• Dropdown: This is a massive space-saver. It shows only the currently selected item and collapses all other options into a dropdown menu. Use this when you have a long list of filter values (like countries or customer names).
• Tile: This option shows the options as clickable buttons. When combined with the "Orientation" setting, you can change the buttons to be horizontal.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Working with Date and Numeric Slicers

Slicers automatically adapt based on the type of data you add to them. When you drag a date field or a numeric field into a slicer, they behave differently than text fields.

Date Range Slicers

When you use a date field, the slicer usually defaults into a range slider. This lets users select a start and end date using draggable handles to filter data by a period.

Within the "Slicer settings > Style" for a date slicer, you can switch between several modes:

• Between: The default slider for setting a start and end date.
• Before / After: Lets you set a single cutoff date.
• List / Dropdown: If your dataset only has a few distinct dates, you can present them this way.
• Relative Date: A very handy option that lets users filter by dynamic time periods like "Last 30 days," "Next 2 months," or "This year."

Numeric Range Slicers

Similarly, when you add a numeric column (like "Sale Amount" or "Unit Price"), Power BI creates a numeric range slicer. Users can drag the handles to filter everything between two values. This is far more practical than having a list with thousands of individual dollar amounts to select from.

Improving Slicer Usability

A few minor formatting tweaks can significantly improve the experience for people viewing your dashboard.

• "Select all" option: Under "Slicer settings > Selection," you can enable a "Show 'Select all'" option. This is a user-friendly feature that saves your audience from having to manually CTRL+click every item.
• Search box: Under the slicer's menu (...), you can enable the search functionality. This adds a helpful search bar right inside the dropdown menu, which is especially helpful for slicers with a long list of values.

Pro Tips for Using Slicers More Effectively

Once you've mastered the basics, you can apply some advanced techniques to make your Power BI reports even more powerful and professional.

Syncing Slicers Across Multiple Pages

By default, a slicer on one page of your report only affects the visuals on that same page. But what if you want a filter selection (like a selected year or sales region) to apply across your entire report? That's when you use "Sync slicers".

Go to the View tab in the ribbon at the top and check the box for "Sync slicers". This opens a new Sync Slicers pane. When you select a slicer on your canvas, this pane shows a list of all the pages in your report. You get two options for each page:

1. The checkmark in the "sync" column will synchronize the filter selection with an identical item already placed on another page. The eyeball column shows or hides the chosen slicer on a page.

This creates a consistent and seamless experience as users navigate between pages, as they don't have to keep re-applying their selection after every navigation click.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Hierarchy Slicers for Multi-level Filtering

You can create expandable and collapsible slicers for multi-level filtering. For example, you can filter by Region, then expand to Country, and further into City within that Region.

To enable the hierarchy, simply add a higher-level value above a lower one in your slicer. You will see an arrow at the side of each item that allows you to navigate to the dropdown list of its levels. The same behavior applies if you build this feature by dropping the name of a predefined hierarchy you created previously in PowerPivot.

Final Thoughts

The simple slicer, easily found by its funnel-like icon, is a cornerstone of an engaging and interactive Power BI report. By understanding how to not just use it, but also how to customize it effectively, you can create intuitive dashboards that allow your users to quickly understand the data they need.

Building an interactive report might seem complex and lengthy, involving many tools and operations to gain mastery over your data. In contrast, you could use plain English commands to let an AI build your view of the data. We built Graphed with marketers in mind, offering a tool that lets you simply type commands like "show sales by country for the last quarter with the top 3 team members", and your charts are generated immediately without needing to search for icons, drag objects onto your dashboard, or format settings. This service gets you back to focusing on insights, saving you time and energy.