Image: monticellllo/Adobe Stock Clicking buttons is a typical action in a lot of apps, and most end users know what a button suggests and how to use it. Designers can add buttons to a report in Microsoft Power BI to carry out simple actions. For example, you may drop in buttons that display extra insight into the data. Or you might add buttons that supply fast navigation to end users
. In this tutorial, I’ll present you to buttons in Microsoft Power BI by inserting 2 buttons into a two-page report. The button on Page 1 will transfer to Page 2, and the button on Page 2 will transfer to Page 1. Implementation is quick and simple. There are other ways to browse from page to page, but a button fasts and obvious.
SEE: How to develop reports in Microsoft Power BI (TechRepublic)
I’m utilizing Power BI Desktop on a Windows 10 64-bit system, but you can likewise use Power BI Service. You can download the demonstration.pbix file, AdventureWorks Sales from GitHub. As soon as downloaded, double-click the.pbix file to open it in Power BI and follow along or utilize a.pbix file of your own. If you want a sneak peek at the final results, take a look at this demonstration file.
How to place a button in Power BI
Buttons in Power BI are a simple user interface control that lets the designer produce easy to use reports. End consumers will usually click a button to communicate with the report material in some method. The outcome is a report that acts more like an app.
Placing a button is simple. Initially, click the Insert tab. Then, select Buttons, and choose a button from the dropdown (Figure A). It’s that easy.
Figure A
Pick a button from the dropdown. That’s the easy part. If you recognize with Microsoft 365 apps, you might see that there are more “buttons”than the common rectangle-shaped button that you’re used to seeing. Shapes are offered as well. Now, let’s proceed and create a button that works to do.
How to assign an action to a button in Power BI
Power BI reports typically make up several pages, which is a good opportunity to present buttons. Particularly, as the designer, you may add buttons that permit users to quickly browse in between pages. You could also utilize page and bookmark navigators for this task, but buttons are familiar to everybody and offer the user a choice as to when or even if they navigate to another page.
Figure B shows 2 pages of an easy report. We’ll insert an arrow button to each page that when clicked accesses the other page.
Figure B
We’ll include buttons for navigating between both pages. Initially, let’s place a button to Page 1. Click the Insert tab. Then, select Buttons, and pick a right-arrow from the dropdown. Drag the arrow to the top-right corner of Page 1 utilizing Figure C as a guide.
Figure C
Include a button to page 1. Let’s make the button a bit larger so it sticks out. If needed, broaden the Format pane. Then, click the General menu, and broaden Properties. Click the Lock Aspect Ratio to enable this function, and change the Height and Width homes to 100 (Figure D).
Figure D
Make the arrow button a bit larger. Now that the arrow is more noticeable, let’s provide it a navigation job. Click the Button menu, and expand the Action section. Enable the Action section, if required, by clicking the Off/On button. From the Type dropdown, pick Page Navigation. Then, from the Location dropdown, choose Page 2 (Figure E).
Figure E
Select the Page Navigation action. For this example, turn the ScreenTips choice off. Nevertheless, you might add “Go to page 2,” if you desired. If you leave this option allowed, but enter no message, Power BI will show a default ScreenTip. Repeat the above process for Page 2, however utilize the left arrow instead, and pick Page 1 from the Destination dropdown (Figure F).
Figure F
Configure a button for page 2 that relocates to page 1. When published, the two buttons will work as navigation buttons. How to publish a report in Power BI Up until you release the report, the buttons won’t work, so click Publish, and click Conserve when prompted. Then, click the link to the released report when provided. At this moment, if you’re not signed into your Microsoft account, you will require to sign in when triggered.
Once released, users can click the ideal arrow on Page 1, displayed in Figure G, to accessPage 2.
Figure G
Click the
right arrow to go to page 2. Figure H shows the left arrow that users can click to go back to Page 1. Figure H< img src ="https://d1rytvr7gmk1sx.cloudfront.net/wp-content/uploads/2022/10/PBIButtons_H-770x457.jpg"alt="Sales Quantity by Country-Region control panel in Power BI. "width=" 770 "height=" 457 "/ > Click the left arrow to go back to page 1. Why utilize buttons in Power BI? You may be questioning why the designer would add navigation arrows when the user can use the links in the Pages pane. Most importantly, this was a simple intro to the use of buttons that carry out actions in a published report. Second, the Pages pane might not be available to all users.
This demonstration is simple on purpose, but you can see how quickly and quickly it is to add buttons that recognize to users. Everyone understands what a right and left arrow methods. On the other hand, you might insert buttons that show the text “Go to page 1” and “Go to page 2.”
Stay tuned
We added two easy buttons to navigate in between 2 pages, but you can use a conditional button instead. In a future short article, I’ll show you how to use one button that understands what page you’re on and returns to the other page when clicked.
