How to Change Slicer Settings in Power BI

Slicers are one of the most powerful and intuitive ways to filter data in your Power BI reports. Instead of using a clunky filter pane, you can provide users with simple, interactive buttons, dropdowns, or sliders to explore the data for themselves. This article will guide you through all the essential slicer settings, from basic formatting to advanced synchronization, helping you transform your static reports into dynamic dashboards.

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

What Exactly is a Slicer in Power BI?

Think of a slicer as an on-canvas visual filter. While the Filters pane in Power BI is powerful, it can be hidden or unintuitive for non-technical users. A slicer brings those filtering capabilities directly onto the report page, making it obvious and easy for anyone to interact with the data.

For example, instead of asking your audience to find the "Filters" pane, expand the "Year" field, and check a box, you can simply place a "Year" slicer on the report with buttons for 2022, 2023, and 2024. This simple change significantly improves the user experience and encourages exploration.

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

Adding a Basic Slicer to Your Report

Before we dive into the settings, let's start with the basics. Adding a slicer to your Power BI report is incredibly straightforward. If you're completely new to slicers, follow these initial steps, otherwise, feel free to skip ahead to the customization sections.

1. Open Your Report: Launch Power BI Desktop and open the report you want to work on.
2. Select the Slicer Visual: In the Visualizations pane on the right-hand side, click on the slicer icon (it looks like a funnel with a filter icon). This will add a blank slicer template to your report canvas.
3. Add Your Data: With the blank slicer selected, drag a field from your Data pane into the "Field" well in the Visualizations pane. For example, drag "Product Category" or "Region" into this box.

That’s it! The slicer will automatically populate with unique values from the field you selected, such as "Electronics," "Apparel," and "Home Goods." Now you have a working slicer that filters all the other visuals on your report page. Let's start making it better.

Mastering the Slicer Settings

The real power of slicers comes from their deep customization options. To access them, click on your slicer to select it, then click the paintbrush icon in the Visualizations pane to open the Format visual pane. This is where you’ll find all the settings to change how your slicer looks and functions.

These settings are organized into two main tabs: Visual and General. Let's break down the most important options in each.

1. Slicer Settings (Under the 'Visual' Tab)

This is the most critical section for controlling how your slicer behaves. Expand the "Slicer settings" option to see the good stuff.

Type of Slicer

The type of slicer you choose depends entirely on the kind of data you're working with.

• List (Vertical): This is the default slicer type for text-based data. It displays all the options in a simple, scrollable list with checkboxes. It's best for when you have a small number of items (maybe 10 or less) and plenty of canvas space.
• Dropdown: This is a space-saving alternative to the list. It shows only one item at a time with a dropdown arrow to reveal the rest. It's perfect for long lists of items like "Customer Name" or "Product SKU," where a list slicer would clutter your report.
• Tile (Horizontal): By changing the slicer's Orientation to Horizontal, you can create modern, button-like slicers often called 'tiles' or 'chiclets'. This is visually appealing and highly effective for a few key options like "This Month vs. Last Month" or "Marketing vs. Sales."
• Between: When you use a numeric or date field, Power BI gives you this option. The "Between" style creates a slider with two handles, allowing users to select a range. It’s perfect for filtering by price range, date range, or age groups.
• Relative Date / Relative Time: These powerful options appear when you use a date/time field. Instead of making users pick specific dates (e.g., Nov 1 to Nov 30), a relative slicer lets them filter by "Last 7 days," "Next 2 weeks," or "This quarter." This keeps your reports evergreen, as the filter dynamically updates based on the current date.

Selection Controls

You can fine-tune how users select items within your slicer.

• Allow multi-select with CTRL: By default, this is on, meaning users must hold the CTRL key to select multiple items. For new users, this isn't always obvious.
• Single select: If you turn this toggle On, users can only select one option at a time. The checkboxes will be replaced with radio buttons, making it clear that only one choice is possible. This is useful for forcing a user to focus on a single category or region.
• Show "Select all" option: Turning this toggle On adds a "Select all" option to the top of your slicer list. It’s a huge quality-of-life improvement that saves users from having to manually check every single box if they want to see everything again.

Have a Long List? Enable Search

Just below the primary "Slicer settings," you'll often see a search box option in the formatting pane itself. When you add a text slicer with many values (like hundreds of product names), a simple list is impossible to use. Enable the search function to add a search bar directly into the slicer visual, letting users quickly type and find the options they’re looking for.

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

2. Formatting Slicer Appearance (Under the 'Visual' Tab)

Once your slicer behaves correctly, it's time to make it look good and match your report's design.

Slicer Header

The header is the title that appears inside the slicer visual itself (e.g., "Product Category").

• Show/Hide: You can turn the header off entirely if the purpose of the slicer is obvious without it.
• Text: You can edit the title text here. By default, it uses the field name, but you can change it to something more user-friendly, like changing "ProductCategoryName" to "Select a Category."
• Formatting: You can change the font family, size, color, and apply bold, italics, or underline to make it stand out.

Values

This section formats the actual items in your slicer list (e.g., "Electronics," "Apparel").

• Font Formatting: Just like with the header, you have full control over the font color, size, and style.
• Background and Padding: You can add a background color to the items or adjust the padding to increase spacing, which can improve readability. Setting a subtle background color for unselected items and a different, more prominent color for selected items is a great way to provide clear visual feedback.

3. General Formatting Settings (Under the 'General' Tab)

These settings affect the entire slicer visual container, not just the elements inside it.

• Title: This adds a title above the slicer visual, separate from the slicer header inside it. This is useful for adding more context or a call-to-action, like "Filter Report By:"
• Effects: Here, you can change the slicer’s background color, add a border to make it pop, or apply a shadow effect to give it some depth on the page.

Advanced Slicer Technique: Syncing Slicers Across Pages

One of the most powerful but often overlooked features is "Sync Slicers." By default, a slicer placed on one page of your report only filters the visuals on that same page. When you move to another page, the filter is gone.

Sync Slicers lets you link a single slicer to multiple pages, creating a consistent filtering experience across your entire report. Here’s how to set it up:

1. Navigate to the View tab in the Power BI Desktop ribbon.
2. In the "Show panes" section, check the box for Sync slicers. A new "Sync slicers" pane will appear.
3. Click on the slicer you want to sync (e.g., your "Region" slicer on the Overview page).
4. The pane now shows a list of all the pages in your report. You will see two columns with checkboxes: one with a sync icon (synchronize) and one with an eye icon (visibility).
5. For every page you want the slicer to filter, check the box in the sync column.
6. For every page where you also want the slicer to be visible, check the box in the eye column as well.

You can use this to have a master slicer on your first page that filters the data on five other pages, without having to copy-paste the slicer everywhere. It makes your reports cleaner and far more powerful for end-users.

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

Best Practices for Slicer Design

Knowing the settings is half the battle. Using them effectively is the other half. Keep these tips in mind as you build your reports:

• Save Space with Dropdowns: For any list with more than 10-15 items, use a dropdown slicer to keep your report clean.
• Use Buttons for Key Choices: If you only have 2-5 important options (e.g., Quarters Q1/Q2/Q3/Q4), use a horizontal tile slicer. They are easier and faster to click than a list or dropdown.
• Less is More: Don't overwhelm users with dozens of slicers. Stick to the 3-5 most important filters they'll need for analysis. Place less-used filters in the Filters pane.
• Clarity Above All: Use clear titles and headers. A user should instantly understand what a slicer does without having to guess.

Final Thoughts

Mastering slicers is a fundamental step toward building truly professional and user-friendly Power BI reports. By moving beyond the defaults and carefully applying different styles, selection controls, and formatting, you can dramatically improve how people interact with your data, enabling them to discover insights on their own.

Tweaking all these report settings is powerful, but building complex dashboards from the ground up often involves a lot of manual busywork across different platforms before you can even get to features like slicers. At Graphed we created a way to skip that entire process. You can connect your marketing and sales data sources like Google Analytics, Shopify, or Facebook Ads in seconds and then simply ask for the dashboard you need in plain English. We handle the analysis and visualization for you, delivering live, shareable dashboards instantly, so you can spend less time configuring visuals and more time acting on insights.