How to Add Buttons in Power BI Dashboard

Buttons can completely change the way your audience interacts with a Power BI report, turning it from a static page of charts into a dynamic, app-like experience. Learning to use them properly lifts your dashboards to a new level of professionalism and usability. This guide will walk you through exactly how to add, configure, and customize buttons to make your reports more intuitive and powerful.

Why Should You Use Buttons in Power BI?

While you can navigate a Power BI report using the tabs at the bottom, dedicated buttons offer a much cleaner and more guided experience for your end-users, especially for those unfamiliar with Power BI. They aren't just for looks, they provide real functional benefits.

• Improved User Experience (UX): Buttons create an intuitive, web-like navigation system. Users instinctively know that a button is meant to be clicked to perform an action, which can significantly lower the friction of exploring your report.
• Guided Analytics: You can use a series of buttons to guide your audience through a specific story or analytical path. This ensures they see the most important insights in the order you intend.
• Simplified Interactions: Instead of asking users to right-click a visual to drill through or manually clear filters, you can create obvious buttons labeled "View Details" or "Reset Filters" to simplify these common actions.
• A Cleaner Report Canvas: Custom navigation panes built with buttons can free up valuable screen real estate, allowing you to hide slicer panes or toggle between different views on the same page.

Getting Started: An Overview of Button Types

Power BI provides several pre-configured button types to get you started, as well as a blank option for full customization. You can find them under the Insert tab in the ribbon.

Here’s a quick rundown of the main built-in options:

• Back: A simple button with a pre-set action to take the user to the previous page they were viewing in the report.
• Bookmark: Designed to be linked to a Bookmark, which is a saved state of a report page. This is incredibly powerful for toggling visuals or filter states.
• Page navigation: A newer feature that allows you to quickly build a navigation experience for your report pages automatically.
• Drill through: A button that becomes active only after a user has selected a relevant data point, making the drill-through action much more obvious.
• Q&A: Creates a button that launches the Power BI Q&A explorer, letting users ask questions about the data using natural language.
• Web URL: Lets you create a link to an external webpage or document.
• Blank: The most flexible option. A completely unstyled button that you can customize with your own text, icons, and actions. It's the one you'll likely use most often for custom navigation.

How to Add a Button to Your Report Canvas

Adding a button is a straightforward process. Let’s start by adding a simple Blank button that we'll configure to navigate to another page.

1. On the Power BI Desktop ribbon, click on the Insert tab.
2. Find the Elements group and click the dropdown arrow on the Buttons option.
3. Select Blank from the list.
4. A blank, rectangular button will appear on your report canvas. You can click on it and drag it to your desired position or resize it using the handles on its border.

With an unconfigured button on your page, you’re ready for the most important step: telling the button what you want it to do when someone clicks it.

Configuring Button Actions and Navigation

The real power of a button comes from its "Action." With the button selected on your canvas, go to the Format pane on the right-hand side. At the top of the formatting options, you’ll see a toggle for Action. Switch it on to see the available types.

1. Page Navigation

The most common use for a button is navigating between report pages. This is perfect for creating a main menu or a simple "Next Page" button.

• How to set it up: In the Action settings, select Page Navigation as the Type.
• A new dropdown called Destination will appear. Click it and select the specific report page you want the user to be sent to when they click the button.
• Now, to make it clear what the button does, go to the Style options in the Format pane. In the Text field, type a clear label like "View Sales Details."

2. Bookmark

Bookmarks save a specific "state" of a report page, including its filters, slicers, and a visual's properties (like visibility). This lets you use buttons to create incredibly interactive experiences, like toggling between a chart and a table view of the same data.

• First, create your Bookmarks:
• How to link a button to a Bookmark: Select your button, go to the Action settings, and set the Type to Bookmark.
• In the Bookmark dropdown, choose one of the bookmarks you just created (e.g., "Show Table"). Add text to the button like "View Table."
• You can now create a second button linked to the "Show Chart" bookmark, allowing users to toggle between the two views with a simple click.

3. Drill through

A drill-through action lets users navigate to a detailed page that's filtered to the specific data point they selected on the original page. While users can right-click to access this, a button makes the option much more visible.

• How to set it up: On the drill-through destination page, add a field to the "Drill through" filters area at the bottom of the Visualizations pane.
• Back on your main summary page, select your button. In the Action settings, set the Type to Drill through.
• Set the Destination to your detail page.
• By default, the button will appear disabled. It will only become active and clickable once a user selects a data point in a visual that uses the field you specified for the drill-through.
• Power BI also allows you to add conditional text to the disabled state of the button. You can set the button text to something like "Select a Product to View Details," providing instructions to your user.

4. Web URL

This is a simple one. If you want to link out to an external resource, like a corporate website or a data dictionary, you can configure a button to open a URL in a new browser tab.

• How to set it up: Select the button, activate the Action, and set the Type to Web URL.
• A Web URL field will appear. Simply paste the full URL (including http:// or https://) into the box.

Customizing Button Style and Appearance

An effective button not only works well but also looks good and fits the design of your report. Power BI gives you full control over the appearance of your buttons through its extensive formatting options.

When you select a button and go to the Format pane > Style, you'll see a State dropdown containing four options: Default, On hover, On press, and Disabled. This is where the magic happens. By customizing each state, you can give your users clear visual feedback.

• Default: The button's appearance when no one is interacting with it.
• On hover: How the button looks when a user moves their mouse cursor over it. A good practice is to slightly change the fill color or add an outline to show it's interactive.
• On press: The appearance when the button is actively being clicked.
• Disabled: For buttons like Drill through that require a selection, this is how it looks when it's not active. Often, this is styled in a faded or grayed-out color.

Within each state, you can customize the following:

• Text: Add a descriptive label to your button. You can change the font family, font size, color, alignment, and padding.
• Icon: Use one of Power BI's built-in shapes or upload your own custom icon image. You can control its placement, alignment, and size relative to the button text.
• Fill: Change the background color of the button. You can even make it transparent if you want to place a clickable zone over another image or visual.
• Outline (Border): Control the color, weight, and transparency of the border around the button.

A Practical Tip: Tooltips!

Under the button's formatting options, there's a field called Tooltip. Whatever text you type here will appear in a small pop-up box when a user hovers over the button. Use this to provide extra context or instructions. For example, for a "Reset Filters" button, a tooltip could say, "Click to clear all selected filters on this page."

Final Thoughts

You now have the knowledge to add, configure actions for, and fully customize buttons in Power BI. By applying these techniques and focusing on a clean, intuitive design, you can transform your reports into highly interactive and user-friendly dashboards that tell a powerful data story.

Learning all the features in powerful BI tools can feel like a full-time job. With that frustration in mind, we created Graphed to be the easiest way for marketing and sales teams to analyze their performance. You just connect your data sources - like Google Analytics, Shopify, or Salesforce - and then describe the dashboard you want in simple English. Our AI analyst builds an interactive, real-time-updating dashboard for you in seconds, saving you from the hours of manual wrangling.