How to Add Slicer to Power BI Dashboard

Power BI slicers transform a static report into an interactive dashboard your team will actually use. Instead of building a separate chart for every category, you can add simple controls that let users filter and explore the data themselves. This guide will walk you through exactly how to add, format, and powerfully use slicers in your Power BI dashboards.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Slicer, Exactly?

Think of a slicer as a user-friendly filter on your report canvas. While you can use the Filters pane in Power BI to narrow down your data, those filters are often hidden and less intuitive for end-users. Slicers bring the filtering capability directly onto the dashboard, giving anyone viewing the report the power to segment data with simple clicks.

For example, instead of having a report that shows total sales for all regions, you can add a slicer for 'Region'. Your boss can then click "North" or "South" to see sales figures for just that specific region, all without having to edit the report themselves. This makes your dashboards incredibly flexible and encourages data exploration.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Add a Slicer in Power BI (Step-by-Step)

Let's start with the basics. We'll add a simple slicer to filter a report by product category. For this example, assume you have a dataset with columns like 'ProductName', 'Category', 'Region', and 'TotalSales'.

1. Select the Slicer Visual: First, find the "Visualizations" pane on the right side of your Power BI canvas. Click the icon for the Slicer. It looks like a funnel with a filter icon on top of it. This will add a blank slicer visual to your dashboard.
2. Drag in Your Data Field: With the blank slicer selected, go to your "Data" pane. Find the field you want to use for filtering. For our example, we'll find the 'Category' field. Click and drag 'Category' into the "Field" well in the Visualizations pane.
3. Your Slicer is Now Live: That's it! Power BI automatically populates the slicer with the unique values from your 'Category' field. You'll see a list of checkboxes next to categories like "Apparel," "Electronics," and "Home Goods." Clicking on any of these checkboxes will instantly filter all the other visuals on your report page to show data for only the selected categories.

You’ve just created your first interactive report element. Clicking on "Electronics" might update your 'Sales by Region' bar chart, your 'Total Sales' KPI card, and your 'Sales by Month' line chart to reflect only electronics sales. This is the fundamental power of slicers.

Customizing and Formatting Power BI Slicers

The default list layout is fine, but you can do so much more to make your slicers fit your report's design and function exactly how you need them to. With your slicer selected, click the "Format your visual" tab (the paintbrush icon) in the Visualizations pane.

Changing the Slicer Style and Layout

Under Slicer settings > Options, you'll find the "Style" dropdown. This is where you can change the fundamental appearance of your slicer:

• Vertical list: This is the default style, perfect for when you have a handful of options.
• Dropdown: This is a must-use for saving space. If you have a long list of filter options (like cities or product names), changing the style to a dropdown collapses the slicer into a single line, keeping your report looking clean and uncluttered. Users can click it to reveal the full list of options.
• Tile: This turns your slicer options into clickable buttons. You can change the "Orientation" under the main "Format" options to "Horizontal" to create a row of buttons at the top of your report, which looks very polished for things like date periods (e.g., 'Q1', 'Q2', 'Q3').

Controlling Selection Behavior

Also under Slicer settings, you can fine-tune how users interact with the slicer.

• Multi-select with CTRL: By default, users need to hold the CTRL key to select more than one item in a slicer. You can turn this OFF to allow users to click multiple checkboxes without any extra keys.
• Show "Select all" option: This is a fantastic quality-of-life feature. It adds a "Select all" option to the top of your slicer list, saving users from having to manually check every single box.
• Single select: If you want users to only be able to select one option at a time (forcing a comparison of one vs. the whole), you can toggle this on.

Working with Different Slicer Types

Beyond simple text categories, slicers are smart enough to adapt to the type of data you give them.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Numeric Range Slicers

If you drag a numeric field, like 'Price' or 'Unit Cost', into a slicer, Power BI creates a slider. This lets users filter for a range of values, like showing all products priced between $50 and $100. In the slicer settings, you can choose styles like:

• Between: The default slider with two handles.
• Less than or equal to: A slider with only one handle to set an upper limit.
• Greater than or equal to: A slider with only one handle to set a lower limit.

This is great for reports where users need to analyze different price tiers or quantities without being limited to fixed categories.

Date Slicers

Date slicers are arguably the most powerful type. When you add a date field to a slicer, you get several layout options:

• List/Dropdown/Tile: Like a text slicer, but showing a list of individual dates.
• Between: A calendar-based range selector that lets the user pick a start and end date.
• Relative Date: This is a game-changer. It allows for dynamic filtering based on the current date. Users can filter by "Last 7 days," "Next 2 weeks," "This Month," or "Last 3 quarters." Power BI automatically figures out the date range, so your report is always up-to-date and relevant.
• Relative Time: For dateTime fields, this works just like Relative Date but lets you filter on minutes or hours.

Advanced Slicer Techniques: Syncing & Hierarchies

Synchronizing Slicers Across Pages

What if you want a single slicer at the top of your report to control charts on multiple pages? By default, a slicer only affects the page it's on. But you can easily change that with "Sync Slicers."

In the top menu, go to View and check the box for Sync slicers. This opens up a new "Sync slicers" pane. When you click on a slicer in your report, this pane shows you a list of all your report pages. For each page, you have two options:

• Sync (first column): Checking this box will make your slicer's selection apply to that page. You could have a slicer on page 1 that also filters visuals on pages 2 and 4.
• Visible (second column, eye icon): Checking this box will make the slicer itself appear on that page. It ensures the slicers are in the same position on every page you select, creating a seamless user experience.

By using these options, you can create a single set of 'master filters' on your first page that governs the entire report.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using Hierarchy Slicers

If you have data with a natural hierarchy, like Category -> SubCategory -> Product, Power BI can handle this beautifully. Simply create a hierarchy in your Data model first. Then, drag that entire hierarchy into the slicer's Field well. The slicer will automatically display the top level (Category) with small chevrons to expand and drill down into the lower levels (SubCategory).

Final Thoughts

Power BI slicers are simple to create but have a tremendous impact on the usability of your reports. They empower your team to move beyond just viewing data and allow them to ask their own questions, explore trends, and find insights directly within the dashboard you built for them.

Creating interactive dashboards in tools like Power BI is a powerful skill, but the learning curve and manual setup process can be time-consuming. We built Graphed because we believe getting answers from your data shouldn't be so hard. By connecting your tools like Shopify or Salesforce, you can use plain English to ask for the data you want to see - "show me a comparison of revenue by campaign for the last 30 days," for example - and we instantly build an interactive, real-time dashboard for you, controls and all. It turns hours of report-building drudgery into a 30-second conversation, giving you more time to act on your insights.