How to Use Buttons in Power BI for Interactive Reports

In Power BI, you use Buttons to add interactive elements like navigation or bookmarks. You insert a button from the Insert tab, then configure its action (like page navigation or bookmark) in the Visualizations pane under Action. Buttons help users interact with reports easily.

Syntax

Buttons in Power BI are visual elements you add from the Insert menu. Each button has properties you can set:

• Type: Choose the button style (e.g., Blank, Back, Reset)
• Action: Define what happens when clicked (e.g., navigate to page, trigger bookmark)
• Tooltip: Text shown when hovering over the button
• Icon and Text: Customize the button's look

These settings are found in the Visualizations pane after selecting the button.

power_bi

Insert > Buttons > Choose Button Type

Visualizations pane > Action > On
Select Action Type (Page navigation, Bookmark, Q&A, etc.)
Set Target (Page name, Bookmark name, etc.)
Customize Tooltip, Icon, and Text as needed

Example

This example shows how to add a button that navigates to another report page called "Sales Details" when clicked.

power_bi

1. Go to the Insert tab and click Buttons > Blank.
2. Select the new button on the canvas.
3. In the Visualizations pane, turn on Action.
4. Set Type to Page navigation.
5. Under Destination, select the page "Sales Details".
6. Optionally, add a Tooltip like "Go to Sales Details".
7. Customize the button text to "View Sales Details" by typing on the button.

Now, when you click this button in reading mode, it takes you to the Sales Details page.

Output

A button labeled "View Sales Details" appears on the report page. Clicking it navigates to the "Sales Details" page.

Common Pitfalls

• Action not enabled: Forgetting to toggle the Action switch on means the button won't do anything.
• Wrong target: Selecting a non-existent page or bookmark causes no navigation.
• Button overlaps: Placing buttons over visuals can block data interaction.
• Confusing labels: Not labeling buttons clearly can confuse users.

Always test buttons in reading mode to confirm they work as expected.

power_bi

Wrong way:
- Insert button
- Set action type but leave Action off

Right way:
- Insert button
- Turn Action on
- Set correct action type and target
- Add clear label and tooltip

Quick Reference

Property	Description	Common Values
Type	Button style	Blank, Back, Reset, Q&A
Action	Enable button action	On, Off
Action Type	What the button does	Page navigation, Bookmark, Q&A, Drill through
Destination	Target page or bookmark	Page name, Bookmark name
Tooltip	Hover text	Custom text
Icon	Button icon	Default or custom
Text	Button label	Any text

Key Takeaways

Always enable the Action toggle to make buttons interactive.

Use buttons to navigate pages, trigger bookmarks, or run Q&A queries.

Label buttons clearly and add tooltips for better user experience.

Test buttons in reading mode to ensure they work correctly.

Avoid placing buttons over important visuals to prevent blocking.