How to Add Page Navigation in Power BI
In Power BI, you can add page navigation to your reports to allow users to easily navigate between different pages or sections of your report. This feature is particularly useful when you have a large amount of data or when you want to organize your report into distinct sections.
Step 1: Create Multiple Pages
The first step is to create multiple pages in your Power BI report. Each page can represent a different section or topic of your report.
Step 2: Add Buttons or Links
Next, you need to add buttons or links on each page to enable navigation to other pages. You can use shapes, images, or text boxes as buttons.
To add a button, follow these steps:
- Select the shape, image, or text box that will act as the button.
- In the “Visualizations” pane, go to the “Format” section.
- Under the “Action” category, toggle the “Action” switch to “On”.
- Select “Page navigation” as the type of action.
- Choose the target page from the drop-down list.
Step 3: Customize Button Design
You can also customize the design of your buttons to make them visually appealing and consistent with your report’s theme. Use the formatting options available in the “Format” section of the “Visualizations” pane to change the button color, font, and size.
Step 4: Test and Publish Your Report
Once you have added page navigation buttons to your report, it’s important to test them to ensure they work as expected. You can do this by previewing your report in Power BI Desktop or by publishing it to the Power BI service and testing it there.
If everything looks good, publish your report to Power BI service to share it with others. They will be able to navigate between pages by clicking on the buttons or links you have added.
Example:
Let’s say you have a sales report with three pages: “Overview”, “Product Sales”, and “Regional Sales”. On the “Overview” page, you can add buttons that link to the other two pages.
For example, you can create a rectangle shape, format it as a button, and add a text box inside that says “Product Sales”. In the “Action” settings, select “Page navigation” and choose the “Product Sales” page as the target page.
Repeat the same process to create a button for the “Regional Sales” page. Now, when users view the “Overview” page, they can click on these buttons to navigate to the corresponding pages.