How to Add a Button in Power BI

Adding a button to a Power BI report might seem like a small detail, but it’s one of the best ways to transform your report from a static collection of charts into a dynamic, app-like experience for your users. Buttons let you control navigation, filter data, and guide your audience through a data story. This article will walk you through exactly how to add, format, and configure buttons in Power BI to make your reports more interactive and intuitive.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Using Buttons in Power BI?

In a world of dashboards and reports, user experience is king. If your team or clients can't easily find the information they need, the report has failed. Buttons bridge this gap by making navigation obvious and user-driven.

Instead of relying on users to right-click menus or find the small page tabs at the bottom of the screen, you can create a clean, guided flow. Think of it like a website's navigation bar - buttons provide a clear path for users to follow. Here are a few key benefits:

• Improved Navigation: Guide users between different pages or views within your report with a single click.
• Enhanced Interactivity: Allow users to toggle visuals, apply filters, or reset the view to its original state, giving them more control over their analysis.
• Better Storytelling: Structure your report like a narrative, with "Next" or "See Details" buttons that lead users logically from a high-level overview to a more granular breakdown.
• A Professional Look and Feel: Well-designed buttons give your report a polished, professional finish, making it feel less like a spreadsheet and more like a custom-built application.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Add a Button to Your Report

Getting a button onto your Power BI report canvas is refreshingly simple. Power BI offers several pre-styled buttons for common actions as well as a blank slate for complete customization.

Follow these steps to add your first button:

1. Open your report in Power BI Desktop.
2. Navigate to the Insert tab in the main ribbon at the top of the screen.
3. In the Elements section, click the dropdown arrow next to Buttons.

You’ll see a list of options:

• Arrows (Left, Right): Simple directional navigation.
• Back: Pre-configured to take users to the previous page they were viewing.
• Bookmark: Designed to activate a bookmark (we'll cover this in detail later).
• Blank: A completely unformatted button, giving you a fresh canvas for your own design. This is often the most flexible and powerful option.
• Other Icons: Options like Information, Q&A, and Help provide visual cues for their purpose.

For this tutorial, select Blank. A simple grey rectangle will appear on your report canvas. You can now drag it to position it where you want and resize it by dragging the corners, just like any other visual.

Customizing Your Button's Appearance

A plain grey button isn't very inspiring. The real power lies in the formatting options that let you design a button that fits your report's theme and clearly communicates its purpose. With your new button selected, the Format pane will appear on the right side of the screen. Let’s look at the key settings you'll use.

Shape and Style

Under the Shape dropdown, you can change the button from the default Rectangle to other options like a Rounded Rectangle or an arrow. Underneath, you'll find the Style settings. This is where you define the look and feel for the different "states" a button can be in - this is what gives users crucial visual feedback.

• Default State: This is how the button looks when no one is interacting with it. Customize its fill color, transparency, text, and icon.
• On Hover: How the button changes when a user’s mouse cursor moves over it. A common technique is to slightly lighten or darken the fill color to signal that it's clickable.
• On Press: The style when a user clicks the button. You might make the button slightly smaller or change its color dramatically to confirm the click has been registered.
• Disabled: For scenarios when the button is not active. This is useful for drill-through actions that are only available after a user makes a selection.

Customizing each state is the secret to making your report feel incredibly responsive and professional. For each state, you can adjust the following:

• Text: Turn this on to add a label like "View Sales Details." You can control the font, size, color, and alignment. A great tip is to change the font color on hover to make it pop.
• Icon: You can add a pre-built icon or upload your own custom image. Icons help communicate the button’s function at a glance.
• Fill: This controls the main background color of the button. Set a unique color for each state to create a clear visual interaction.
• Outline: Control the border around the button, including its color and width.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Configuring Button Actions: Making It Work

A pretty button is useless if it doesn't do anything. The real functionality comes from the Action card in the Format pane. Select your button, expand the Action section, and toggle it to On.

You’ll now see a Type dropdown menu with several options. Let's cover the most common and powerful ones.

1. Page Navigation

This is the most straightforward button action. It turns your button into a simple link to another page within your Power BI report.

• How to set it up: Set the Type to Page Navigation.
• Under Destination, a new dropdown will appear showing all the pages in your report. Simply select the page you want the button to link to.
• Example: Place a "View Details" button on your main sales summary page. Set its destination to your "Sales Breakdown" page for a seamless transition.

2. Bookmark

This is arguably the most versatile and powerful action type. Bookmarks in Power BI allow you to save a specific “state” of a report page - including any applied filters, slicers, or visibility settings for visuals. Buttons activate these bookmarks.

Example: Toggling a Chart's Visibility

Imagine you want to give users a choice between two views: a table and a chart. You can use buttons and bookmarks to toggle between them.

1. Place both your table and chart visuals on the report canvas, perhaps overlapping each other.
2. Go to the View tab and open the Bookmarks and Selection panes.
3. Create the "Chart View" Bookmark: In the Selection pane, hide the table visual by clicking the eye icon next to its name. Ensure your chart visual is visible. Now, in the Bookmarks pane, click Add and rename the new bookmark to "Show Chart."
4. Create the "Table View" Bookmark: In the Selection pane, hide the chart visual and make the table visual visible. In the Bookmarks pane, click Add and rename this bookmark to "Show Table."
5. Now, add two buttons to your report, labeling them "Chart View" and "Table View."
6. Select the "Chart View" button, go to its Action settings, set the Type to Bookmark, and select the "Show Chart" bookmark from the dropdown.
7. Do the same for the "Table View" button, assigning it the "Show Table" bookmark.

Congratulations! You've just created an interactive toggle that lets users switch between views without needing to change pages.

3. Drill through

Drill-through allows users to navigate to a more detailed page about a specific data point. For example, clicking on a specific product in a chart and then clicking a drill-through button to go to a product detail page filtered for that product.

• How to set it up: First, you need to set up the destination page (the detailed page). On that page, drag the field you want to filter by (e.g., "Product Name") into the Drill through field well in the Visualization Pane.
• Back on your original page, add a button and set its Action Type to Drill through.
• Under Destination, select the detailed page you set up.

Now, the button will remain greyed out until a user selects a data point to drill through, ensuring the button can only be used with the appropriate context. Once a user selects "Product A" from a chart, the button will become active, and clicking it will take them to the product detail page showing only data for "Product A."

Graphed

Still Building Reports Manually?

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

Watch the Demo

4. Web URL

A simple yet effective action, this turns your button into a hyperlink to an external website.

• How to set it up: Set the Type to Web URL.
• In the Web URL field, paste the URL you want the button to link to.
• Example Use Cases:

Final Thoughts

Buttons elevate Power BI reports from simple data visualizations into interactive analysis tools. By mastering the combination of shapes, styles, and actions, you can create intuitive and engaging experiences that empower users to find the insights they need. Take your time to set up your button's states and actions - a little extra effort here can go a long way in creating a professional-quality report that your team will love using.

While manually creating custom navigation and interactivity as we've discussed is very powerful, it can also be time-consuming. At Graphed, we make data analysis and visualization instantaneous. Instead of spending hours figuring out the perfect button configurations or building bookmarks, you can just use Graphed to build dashboards in seconds. Streamline the data process, so you can spend your time acting on insights, not just building the reports.