How to Make Slicer Multi Selection in Power BI

Trying to compare multiple items in a Power BI report but can only click one option in your slicer at a time? It's a common frustration, but the fix is incredibly simple. This guide will show you exactly how to enable multi-selection on your Power BI slicers, transforming them from restrictive single-click filters into flexible, user-friendly tools. We'll cover how to add checkboxes, include a "Select All" option, and share some best practices for making your reports more intuitive for your audience.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Power BI Slicer and Why is Multi-Selection So Important?

In Power BI, a slicer is essentially a user-facing filter. It provides buttons, lists, or dropdowns on your report canvas that let viewers easily segment and filter the data they're looking at. For example, you could have a slicer for "Region," allowing a user to click "North America" and see all the charts and tables on the page update to show data only for that region.

By default, when you first create a list slicer in Power BI, it's set to single-selection. You click one item, and it filters the report. If you want to select another, you have to hold down the Ctrl key while you click. This Ctrl-click method is the standard way to multi-select in many applications, but it's not always obvious to everyone using your dashboard. Your sales manager, marketing director, or client probably won't guess they need a keyboard shortcut to compare their top three sales regions. This is where a more intuitive approach comes in handy.

Enabling a proper multi-selection interface - usually with checkboxes - removes the guesswork. It makes your report feel more like a modern web application and allows users to easily analyze and compare multiple segments of data at once. This small tweak dramatically improves the user experience and the overall effectiveness of your dashboards.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Setting the Stage: Creating a Basic Slicer

Before we adjust the settings, let's make sure we have a standard slicer to work with. If you already have one, you can skip to the next section. Otherwise, here's a quick refresher.

1. Open your report in Power BI Desktop.
2. In the Visualizations pane, click on the Slicer icon. It looks like a small funnel next to a table.
3. An empty slicer visual will appear on your report canvas. Drag the corners to resize it and position it where you want - usually on the left side or top of the report.
4. With the slicer selected, go to the Data pane and drag a categorical field into the "Field" well. This could be anything like "Product Category," "Country," "Campaign Name," or "Sales Rep."

You now have a basic slicer. If you click on "Electronics" and then click on "Apparel," you'll notice the selection jumps from one to the other instead of selecting both. Now, let's go fix that.

How to Enable Multi-Selection on a Power BI Slicer

The key to unlocking multi-selection lies in the formatting options for the slicer visual. This is where you can customize everything from its appearance to its behavior. We'll disable the "Ctrl-click" requirement to make selections more intuitive.

Step-by-Step Guide to Turning On Multi-Select

Follow these simple steps to transform your single-select slicer into a multi-select masterpiece with checkboxes:

1. Select Your Slicer: Click on the slicer visual on your report canvas to activate it. You'll see the border light up with handles for resizing. Make sure your slicer is in ‘list’ format, which is best for this guide.
2. Open the Formatting Pane: On the right side of the Power BI interface, you will find the Visualizations pane. With the slicer selected, switch over to the Format your visual tab which has a paintbrush icon. This will take you to where our slicer settings can be changed.
3. Navigate to Slicer Settings: In the "Format your visual" tab, you'll see a list of formatting categories like "Slicer settings," "Slicer header," "Values," etc. Click on Slicer settings to expand its options. Within these options will be a section named Selection.
4. Disable 'Multi-select with CTRL': Under the Selection section, find the Multi-select with CTRL option. By default, this option is turned on. Click the toggle to turn it off.

That's it! The moment you turn this off, checkboxes will appear next to each item in your slicer list. Now, you and your users can simply click the checkboxes to add or remove items from the filter without holding down any keys. It's that easy to make your report more user-friendly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Taking it a Step Further: Adding a "Select All" Option

Now that you have intuitive multi-selection working, there's one more powerful feature you can add to give your users even more control: a "Select All" option.

When you have a long list of items in your slicer - say, 50 different countries or hundreds of products - it's tedious to click every single checkbox. A "Select All" function lets users quickly select or deselect every item in the list with a single click.

How to Add the "Select All" Option

The setting is located right where we were before, making this a quick and easy enhancement.

1. Select Your Slicer: If it isn't already, click on your slicer visual.
2. Go Back to Slicer Settings: Navigate back to the Format your visual pane > Slicer settings and find the Selection option.
3. Enable ‘Show “Select all”’: Within the Slicer setting, look for the subsection titled Show “Select all”. Click the toggle to turn this option on.

As soon as you turn this on, a new "Select all" checkbox will appear at the very top of your slicer list. Clicking it will check every box below it. Clicking it again will uncheck everything. This is a must-have for any slicer with more than a handful of items and is a signature touch of a thoughtfully designed dashboard.

Slicer Style and Best Practices

While enabling multi-select is the biggest hurdle, you can further refine your slicers to improve functionality and aesthetics. Here are a few settings and best practices to consider:

1. Choose the Right Style: List vs. Dropdown

Under Format visual > Slicer settings > Style, you can choose between a "Vertical list" and a "Dropdown".

• Vertical List: This is the default and works perfectly with checkboxes. It's ideal when you want the filter options to always be visible and you have enough space on your canvas. It's best for slicers with fewer than 10-15 items.
• Dropdown: This style condenses your slicer into a single-line box that opens a list when clicked. It's a fantastic space-saver for crowded reports or slicers with very long lists. Multi-select with checkboxes and "Select All" work perfectly here as well. This can be advantageous for providing users with different time periods or departments to select from.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Enable the Search Bar for Long Lists

If your slicer contains dozens or even hundreds of items (like SKUs, store names, or employees), scrolling through the list is impractical. Power BI has a built-in search function to solve this.

• With the slicer selected, click the ellipsis (...) menu on the visual’s header.
• Select Search from the menu that appears.

An even easier way to enable search within filters is:

• Navigate back to the formatting options pane by selecting the filter from your Power BI canvas again.
• Within the options provided is the choice to have both a Slicer header and a search bar at the very top of your slicer to help find and select options rapidly.

A search box will be added to the top of the slicer, allowing users to type a few letters and instantly narrow down the list to what they are looking for before applying any selections.

Final Thoughts

Mastering the multi-select slicer is a fundamental step toward creating Power BI reports that are not only powerful but also genuinely easy and intuitive to use. By moving away from the default Ctrl-click behavior and embracing checkboxes and the "Select All" option, you empower your users to explore their data more freely and arrive at insights faster.

If you've ever felt that building reports in tools like Power BI takes more time than you have, we understand. We created Graphed to remove the friction from data analysis. Instead of clicking through formatting menus, you can connect your data sources and create real-time marketing or sales dashboards by simply describing what you want to see - like, "Create a line chart showing sales by region for the past year." Our AI agent handles the rest, turning hours of building and tweaking into a 30-second conversation, allowing you to focus on the insights, not just the setup.