How To Add Buttons In Power Bi

by

How to Add Buttons in Power BI

Power BI does not have a direct button control, but you can create buttons using shapes and bookmarks. Here’s the step-by-step process:

  1. Open Power BI Desktop and go to the report page where you want to add the buttons.
  2. On the “Home” tab, click on “Shapes” in the “Insert” group.
  3. Choose a shape that you want to use as a button (e.g., rectangle).
  4. Click and drag on the report canvas to create the button shape.
  5. Resize and style the shape to make it look like a button.
  6. Right-click on the button shape and select “Add Bookmark”.
  7. In the “Add Bookmark” dialog box, give a name to the bookmark and click “OK”.
  8. Create another shape for the second button, following the same steps.
  9. Repeat this process for all the buttons you want to add.
  10. To assign an action to the button, right-click on the button shape and select “Button Text”.
  11. In the “Tooltip” section, enter the text you want to display on the button.
  12. In the “Action” section, choose “Go to bookmark”.
  13. Select the bookmark you created earlier for that button, and click “OK”.
  14. Repeat this step for all the buttons, assigning different bookmarks to different buttons.

By following these steps, you can create interactive buttons in Power BI. When the user clicks on a button, it will navigate to the corresponding bookmarked page or perform the desired action.

Example:

Let’s say you have a report with two pages – “Sales Dashboard” and “Customer Analysis”. You want to add buttons to navigate between these pages.

1. Follow the above steps to create two rectangular-shaped buttons on the “Sales Dashboard” page.

2. Assign the first button to navigate to the “Sales Dashboard” bookmark (which is the current page) and the second button to navigate to the “Customer Analysis” bookmark.

3. Now, when you publish the report and open it in Power BI Service or share it with others, they can click on the buttons to navigate between the two pages.

Please note that the steps mentioned above are for creating simple navigation buttons in Power BI. You can customize the buttons further by adding icons, changing colors, or using visualizations like Chiclet Slicer, if needed.

Leave a comment