How to Add Select All in Power BI Slicer

One of the most common friction points in Power BI is seeing a list slicer and realizing it's missing a "Select All" option. Your report users are forced to tediously hold down the Ctrl key while clicking through dozens of items just to see the complete picture. This seemingly small detail can make a big difference in how user-friendly and professional your dashboard feels. This tutorial will walk you through the various ways to add a "Select All" option to your Power BI slicers, from the simple built-in setting to a more flexible custom solution using DAX.

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

Why Slicers Need a 'Select All' Option

Slicers are the interactive filters that make Power BI dashboards so powerful. They empower users to explore data on their own terms, drilling down into specific categories, regions, or time periods. However, the default behavior can sometimes work against this goal.

Without a clear "Select All" or "Deselect All" button, report viewers can easily get lost. They might filter down to a single item and then struggle to return to the original, all-encompassing view. This is especially true for users who aren't familiar with the Ctrl+click shortcut or who are viewing the report on a touch device. Adding a "Select All" option removes this ambiguity, providing a clear, intuitive way to reset the filter and view the total dataset.

Method 1: The Simple, Built-in Solution

Fortunately, the Power BI team added a built-in feature to solve this exact problem. For most standard list or dropdown slicers, enabling "Select All" is a matter of flipping a switch. It’s the fastest and most popular way to get this done.

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-by-Step Instructions

Follow these simple steps to activate the option:

1. Select Your Slicer: Click on the slicer visual you want to modify in your Power BI report canvas.
2. Open the Formatting Pane: With the slicer selected, navigate to the Visualizations pane on the right-hand side of the screen. Click on the icon that looks like a paintbrush, labeled "Format your visual."
3. Find Slicer Settings: In the formatting options, expand the section called Slicer settings.
4. Expand the Selection Section: Within Slicer settings, you will see another sub-section named Selection. Click to expand it.
5. Toggle the Switch: You will now see an option that says Show "Select all" option. Simply toggle this switch to On.

Instantly, a new checkbox will appear at the very top of your slicer list. Your users can now click this single box to select or deselect every item in the list at once. This works identically for both list-style slicers and dropdown-style slicers, providing a consistent experience.

Troubleshooting: What if the 'Select All' Option is Grayed Out?

Sometimes you might find the Show "Select all" option is grayed out and you can't click it. This is almost always because your slicer is not configured to allow multiple selections.

Here’s how to fix it:

• Keep the Selection section open in the formatting pane.
• Make sure the option Single select is toggled Off.
• Make sure the option Multi-select with CTRL is toggled On.

Once you allow for multiple selections, the "Select All" option should become clickable again. Power BI requires multi-select to be enabled because "Select All" is, by definition, a multi-selection action.

Method 2: A DAX Solution for Ultimate Control

The built-in option is perfect for most cases, but what if you need more control? For instance, perhaps you want the "All" option to have a different name, like "All Regions" or "Company Total," or you want to ensure that "All" is the default state when nothing is selected. For this level of customization, you can use DAX (Data Analysis Expressions) to build your own solution.

This method involves creating a separate, disconnected table to populate the slicer and then writing a measure that tells your other visuals how to react based on the user's selection.

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

Step 1: Create a Disconnected Table for the Slicer

First, we need to create a new table that contains all the unique values from your slicer category, plus an extra row for "All." Let's imagine you have a sales report and you want to filter by Product Color. Your slicer has values like "Red," "Blue," "Green," etc.

Go to the Modeling tab in Power BI Desktop and click New Table. In the formula bar, enter a DAX expression like this:

Slicer Colors =
UNION(
    DISTINCT('Products'[Color]),
    ROW("Color", "All Colors")
)

Let's break this down:

• DISTINCT('Products'[Color]): This part gets a unique list of all colors from your 'Products' table.
• ROW("Color", "All Colors"): This creates a new, single-row table with a value of "All Colors" in the "Color" column.
• UNION(...): This combines the two tables into one. The result is a new table called Slicer Colors that has all your individual colors plus the "All Colors" option.

Important: This new table is not related to any of your other tables in the data model. This is intentional.

Step 2: Create a Slicer with the New Table

Now, delete your old color slicer. Add a new slicer to your report canvas and drag the 'Color' field from your newly created Slicer Colors table into the Field well of the slicer. You now have a slicer with all the colors and your custom "All Colors" option.

Step 3: Write a DAX Measure to Control the Filter

Right now, the new slicer does nothing because it isn't connected to your data. We need to create a measure that acts as the "logic" for your charts. This measure will check what's selected in the slicer and apply the correct filter.

First, let's assume you have a base measure for total sales:

Total Sales = SUM(Sales[Revenue])

Now, right-click on your Sales table and select New Measure. Enter the following DAX formula:

Filtered Sales =
VAR SelectedOption = SELECTEDVALUE('Slicer Colors'[Color], "All Colors")
RETURN
IF(
    SelectedOption = "All Colors",
    [Total Sales],
    CALCULATE(
        [Total Sales],
        TREATAS(VALUES('Slicer Colors'[Color]), 'Products'[Color])
    )
)

Here’s the logic:

• The VAR statement stores the value selected in our new slicer. If nothing is selected, it defaults to "All Colors."
• The IF statement checks if the selected value is "All Colors."
• If it is, the measure simply returns the regular [Total Sales] measure, showing data for all colors.
• If a specific color is chosen, it uses CALCULATE and TREATAS to filter the actual 'Products'[Color] column based on the selection from our disconnected slicer table.

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 4: Update Your Visuals

The final step is to update your charts and tables to use this new control measure. Instead of using your original [Total Sales] measure, drag the new [Filtered Sales] measure into the values field of your visuals. Now, when you select "Red" in the slicer, your charts will show sales only for red products, and when you select "All Colors," they will show the grand total.

Best Practices for Clear and Effective Slicers

Adding a "Select All" option is a massive improvement, but here are a few other tips to make your slicers even better for your audience:

• Use Dropdowns for Long Lists: If your slicer contains more than 10-15 items, consider changing its style from a list to a dropdown. This saves valuable space on your report canvas. You can change this in the slicer's formatting options under Slicer settings > Style.
• Enable the Search Bar: For very long lists, the search function is a lifesaver. In the formatting options for your slicer, click the three dots (...) at the top right of the slicer header and choose Search. This allows users to quickly find the item they need.
• Think About Default Selections: When a report is first opened, what should the user see? By default, slicers have nothing selected, which usually means all data is shown. If you want a specific filter applied when the report loads, simply make that selection in Power BI Desktop and save the file. That will be the default view.

Final Thoughts

Getting your slicers to work intuitively is a key part of building a great Power BI report. By either enabling the simple "Show 'Select all' option" or building a more customized DAX solution, you can provide a much smoother and less confusing experience for your end-users, saving them from the frustrating task of manually clicking through long lists.

Making data easy to interact with is at the heart of effective reporting. Often, the challenge isn't the data itself, but the friction of the tools we use. Manually finding the right setting in a Power BI format pane or spending time writing DAX for something as simple as a "Select All" button are minor examples of the complexities that slow us down. We built Graphed to remove this friction by letting you build dashboards using simple, natural language instead. Rather than hunting through menus, you can just ask, "Show me my sales by product color," and get an interactive chart in seconds, allowing you to focus on the insights instead of the setup.