How to Add Filter Button in Power BI

Creating an interactive and user-friendly report in Power BI often comes down to how easily your audience can explore the data. While the default filter pane gets the job done, it's not always the most intuitive experience. This guide will show you how to move beyond the basics and add dedicated filter buttons to your reports, making them cleaner, more professional, and simpler for anyone to use.

Graphed

Still Building Reports Manually?

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

Watch the Demo

We’ll cover everything from turning simple slicers into interactive buttons to building a custom, collapsible filter pane that appears and disappears with a click.

Understanding Your Filtering Options in Power BI

Before creating custom buttons, it's important to know the built-in filtering tools Power BI offers. By default, you interact with filters through the Filters pane, which typically sits on the right side of your report canvas. This pane allows you to apply filters at three different levels:

• Filters on this visual: Affects only a single, selected chart or table.
• Filters on this page: Affects all visuals on the current report page.
• Filters on all pages: Applies a filter globally across every page in your report.

While powerful for you as the report creator, the Filters pane can feel a bit technical and cluttered for end-users who aren't familiar with Power BI. It's often hidden by default, and teaching business users to find and use it can be a hassle. That’s why creating visible, on-canvas filter buttons provides a much better experience.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Turn Slicers into Interactive Buttons

The easiest way to create a 'filter button' is by using Power BI's slicer visual and formatting it to look like a set of buttons. This is perfect for when you want to offer users a few clear, primary filtering options, like filtering by year, region, or product category.

Step 1: Add a Slicer Visual to Your Report

First, you need to add the slicer itself. This is a straightforward process:

1. In the Visualizations pane, click on the Slicer icon. A blank slicer will appear on your report canvas.
2. With the blank slicer selected, drag the data field you want to filter by from the Data pane into the "Field" well of the slicer. For this example, let's use a "Product Category" field.

By default, Power BI will likely display this as a vertical list with checkboxes.

Step 2: Format the Slicer as Buttons

Now comes the fun part: making that list look like a series of clickable buttons.

1. Select your slicer on the canvas.
2. Go to the Format visual pane (the paintbrush icon).
3. Expand the Slicer settings section.
4. Click on the Style dropdown and change it from Vertical list to Tile.

Instantly, your list of categories will transform into a block of button-like tiles. You can now resize and rearrange the slicer visual to orient the buttons horizontally or as a grid.

To further refine the look and feel:

• Under Format visual > Values, you can change the font color, background color, and border to make the tiles stand out.
• Under Format visual > Slicer settings > Selection, you can turn on "Single select," which forces the user to choose only one option at a time, just like a button. Keep it off if you want users to be able to select multiple categories (by holding Ctrl + Click).

This method is quick, easy, and dramatically improves the user interface for simple filtering needs.

Method 2: Create a Collapsible Filter Pane with Bookmarks

For more complex reports with many filtering options, placing dozens of slicer buttons on the canvas can make it look messy. The solution is to create a sleek, pop-out menu that contains all your slicers. This keeps the main report clean while giving users access to powerful filtering when they need it.

This technique relies on two key features: the Selection pane and the Bookmarks pane.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Build Your Filter Menu

First, create the physical 'pane' that will hold all your filters.

1. Go to the Insert tab on the ribbon, select Shapes, and choose the Rectangle.
2. Drag the rectangle onto your canvas and resize it to look like a sidebar or a pop-up menu. Position it where you want your filter pane to appear (e.g., on the left side of the screen).
3. In the Format shape pane, change its color to make it stand out from your report background. A light grey or a color from your brand palette works well.
4. Now, add all the slicers you need (for Region, Year, Product Line, etc.) and place them on top of the rectangle you just created.

Step 2: Group the Menu Objects Together

To ensure all parts of your filter menu move and act as one unit, you need to group them.

1. Go to the View tab on the ribbon and open the Selection pane. This pane lists every object on your report page.
2. Hold down the Ctrl key and click to select the rectangle shape and every slicer you placed on it.
3. Right-click on one of the selected items in the Selection pane and click Group. Rename the new group something intuitive, like "Filter Pane Group."

Step 3: Create Bookmarks to Show and Hide the Pane

Bookmarks in Power BI save the state of a report page. We'll use them to save two states: one where the filter pane is visible and one where it's hidden.

1. First, open the Bookmarks pane from the View tab.
2. Create the "Show Filters" Bookmark: With the "Filter Pane Group" visible, click the Add button in the Bookmarks pane. Rename this new bookmark to "Show Filters."
3. Create the "Hide Filters" Bookmark: Now, go to the Selection pane and click the small eye icon next to your "Filter Pane Group" to make it invisible. With the pane hidden, click the Add button in the Bookmarks pane again. Rename this one "Hide Filters."

Crucial Tip: By default, bookmarks also save the data state (current filter and slicer selections). We want to disable this so that our buttons only control visibility. For both the "Show Filters" and "Hide Filters" bookmarks, click the three dots (...), and uncheck the Data option. This is essential for the feature to work correctly.

Step 4: Add Buttons to Trigger the Bookmarks

With our bookmarks in place, the final step is to create buttons that activate them.

1. Create an "Open" Button: Go to Insert > Buttons > Blank (or choose a filter icon). Place this button where it's easily visible on your main report canvas. With the button selected, go to the Format pane, open the Action menu, and turn it on.
2. Create a "Close" Button: Now, insert another button (an "X" shape works well for this). Place this button on top of your filter pane. Open the Action menu for this button.

Now you can test it! Hold Ctrl + Click to simulate a user click in Power BI Desktop. Clicking the filter icon should make your pane appear, and clicking the "X" button should make it disappear.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Bonus: How to Add a "Clear All Filters" Button

A great user experience also includes an easy way to reset everything. Adding a "Clear All Filters" button is incredibly simple and can save your users a lot of frustration from having to manually uncheck every slicer.

1. Go to Insert > Buttons and choose the Reset icon or a blank button. Place it on your report canvas.
2. Select the new button. In the Format pane, expand the Action menu and turn it ON.
3. Set the Type to Clear all slicers.

And that’s it! When a user clicks this button, Power BI will automatically reset every slicer on the page to its default state. This simple action adds a professional touch and makes your report much more usable.

Final Thoughts

By moving beyond the default filter pane and implementing user-friendly slicer buttons or a collapsible menu, you can significantly elevate your Power BI reports. These techniques make your data more accessible and your insights easier to discover, transforming a static report into an interactive and engaging tool for your team.

While mastering Power BI features like bookmarks and actions takes some practice, it gives you precise control over the user experience. Of course, not everyone has the time to design dashboards manually. At Graphed, we automate the entire process. You just connect your data sources - like Google Analytics, Shopify, or Salesforce - and use simple, natural language to ask for a report. Ask us to "create a dashboard comparing sales by region and product category for the last 6 months," and we’ll instantly generate a real-time, interactive dashboard for you, no manual building required.