How to Create a Drop-Down List in Power BI

Adding a drop-down list to your Power BI report is an easy way to make your data feel more interactive and much easier to explore. This simple feature allows you or your colleagues to quickly filter information without cluttering the page. This article will walk you through exactly how to create and customize a drop-down list slicer in Power BI, step-by-step.

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 is a Drop-Down List in Power BI?

In Power BI, what you might call a "drop-down list" is actually a specific format of a visualization called a Slicer. A Slicer is a visual element that you add to your report canvas to filter the other visuals on the page. Out of the box, a slicer often appears as a simple list with checkboxes or buttons.

By changing its style to a drop-down, you get several key benefits:

• Saves Space: A drop-down menu takes up significantly less of your valuable report canvas space compared to a long list of items. This is perfect for keeping your dashboards clean and focused.
• Better for Long Lists: If you need to filter by a field with dozens or hundreds of unique values (like customer names, product SKUs, or cities), a drop-down is much more manageable for the user.
• Improves User Experience: Drop-down lists are a familiar web element that people intuitively know how to use. They empower your audience to self-serve and find the specific insights relevant to them, turning a static report into an interactive tool.

Think of it as adding a "control panel" to your report that lets anyone become their own data analyst without needing to know anything about the underlying model.

Step-by-Step: How to Create a Drop-Down List

Let’s walk through the process of adding and formatting a drop-down slicer. All you need is a Power BI report with at least one data table loaded.

Step 1: Select the Slicer Visualization

First, find the Visualizations pane, which is typically on the right side of the Power BI Desktop window. In this pane, look for the Slicer icon - it looks like a small table with a funnel on it. Click this icon to add an empty slicer placeholder to your report canvas.

You can drag and resize this placeholder just like any other visual element.

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 2: Add Your Data Field to the Slicer

With the new slicer visual selected, look over at your Data pane (also on the right). Find the column of data that you want your users to filter by. This should be a categorical field, not a numerical one.

Good examples of fields for a slicer include:

• Product Category
• Country or Region
• Sales Representative Name
• Marketing Campaign
• Month or Year

Click and drag that field from the Data pane over to the Field well in the Visualizations pane. Dropping it here will populate your slicer with the unique values from that column.

At this point, you will likely see a vertical list of items with checkboxes.

Step 3: Change the Style to Drop-Down

This is where the magic happens. To change the list format into a compact drop-down menu, you need to adjust its settings.

1. Make sure your slicer is still selected.
2. In the Visualizations pane, click on the Format your visual icon (it looks like a paintbrush).
3. Expand the Slicer settings section.
4. Click on the Style option. You’ll see it’s currently set to "Vertical list" or something similar.
5. Select Dropdown from the list of options.

Voilà! Your slicer will instantly transform from a list into a clean, single-line drop-down menu that you can place neatly at the top or side of your report page.

Customizing Your Drop-Down Slicer for a Better UX

Creating the drop-down is just the start. Power BI gives you several options to make it more powerful and user-friendly. To access these, head back to the Format your visual pane with your slicer selected.

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

Adding a "Select All" Option

One of the most common user requests is the ability to quickly select or deselect all items in a filter. Fortunately, it's easy to add.

1. In the Format your visual pane, go to Slicer settings > Selection.
2. Toggle the switch for Show "Select all" option to On.

Now, when a user clicks the drop-down, the very first option will be "Select all," making it easy to see the aggregate data or start a fresh selection.

Allowing Single or Multiple Selections

By default, users can select multiple items in your drop-down by holding the Ctrl key while clicking. Some users might not find this intuitive. You can adjust this behavior under Slicer settings > Selection.

• Single select: Turning this on forces the user to choose only one option at a time. It turns the checkboxes into radio buttons. This is useful when you want to compare metrics for individual items side-by-side but not their combined total.
• Multi-select with CTRL: Leave this on if you want the default behavior. Turn it off to allow users to select multiple items just by clicking them, which can be more user-friendly as they don't need to use the keyboard.

Adding a Search Bar for Long Lists

If your drop-down list contains hundreds of items, scrolling through it is not practical. Adding a search bar is a lifesaver.

1. Click the ellipsis (...) on the top-right corner of the slicer visual itself on the report canvas.
2. A context menu will appear.
3. Click Search.

A search box will now appear inside your drop-down menu, allowing users to instantly type and find the exact item they’re looking for.

Advanced Slicer Techniques

Once you’ve mastered the basics, you can use slicers in even more sophisticated ways to enhance your reports.

Syncing Slicers Across Multiple Pages

What if you want a user’s filter selection on one page to apply to the charts on another page? This is what the Sync Slicers feature is for. It keeps your report experience consistent as users navigate through it.

1. From the top ribbon, go to the View tab.
2. Check the box for Sync slicers. A new pane will appear.
3. Select your drop-down slicer on the canvas.
4. In the Sync slicers pane, you’ll see a list of all the pages in your report. For each page you want the slicer to affect, check the box in the second column (the "sync" column).
5. To make the same slicer appear on other pages, check the box in the first column (the "view" column).

Now, when a user selects a "Product Category" on your summary page, the detailed charts on your "Product Details" page will already be filtered for that category.

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

When NOT to Use a Drop-Down

While drop-downs are great for saving space, they aren't always the best choice. Here's a quick design tip: if your list has 5 or fewer options that users need to switch between frequently, consider using a different slicer style like "Tile."

Tile-style slicers display the options as clickable buttons. This reduces the number of clicks a user needs to make a selection (one click vs. two for a drop-down) and makes all available options immediately visible. You can change this in the same Slicer settings > Style menu.

Final Thoughts

Adding a drop-down list slicer is a fundamental skill in Power BI that helps turn a data-heavy report into an elegant, user-driven dashboard. By mastering this simple component and its customization options, you can significantly improve the clarity and usability of your analytics for everyone on your team.

While Power BI is incredibly powerful, the learning curve can be steep for those who aren’t data professionals. We believe getting answers from your data shouldn't require courses or complex setups. That’s why we built Graphed which allows you to connect your data sources – like Google Analytics, Shopify, or Salesforce – and build real-time dashboards just by asking questions in plain English. Instead of manually adding slicers and configuring visuals, you can simply ask, "Show me product sales by category," and get a fully interactive report in seconds.