Power BI Blog: Dynamic Page Selector Navigation
23 July 2020
Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to create a dynamic page selector for your reports.
Last week, we looked at creating button navigators for our end users to navigate through our report pages.
This involved creating unique buttons on each page and manually assigning where each button would take you. This would be easy on a report with four pages, but it would soon get rather tedious on reports with eight or more pages.
Lucky for us there is another way to do this.
Assume for this example that we have the following report consisting of six pages for six different countries.
As you would imagine, creating buttons for all six pages would prove to be rather tedious. To create an alternative way to navigate through the report, we must create a table with the names of all the different pages in our report. In this example, I have chosen to create the table in Excel. Of course, you can create the table from any source you wish. Please note that the CountryName table has to contain the exact names of each page, otherwise the selection will not work using this method.
Once that is done, load the table into Power BI. We now have a CountryName table:
The trick here is to create a slicer that contains the CountryName field.
I have removed the Slicer Heading and elected to give the slicer the fitting Title of ‘Page Selector’.
Be sure to toggle ‘Single Select’ to On, and I have also changed the slicer to a drop-down list to keep it compact.
The drop-down slicer alone is not able navigate through the pages of the report. The slicer serves as a selection tool for the user to pick the page they want to navigate to. We will need a widget of some sort for the user to click, so that Power BI will know when the user has made their selection and is ready to navigate to the selected page.
I decided to use the arrow icon as my widget. After creating the image, select it and navigate to the Action area in the Visualizations panel. Toggle ‘On’ for the Action option, then select ‘Page navigation’ as Type.
Then click on the ‘fx’ button next to the Destination input field. This will bring up the Destination dialog box. Here, we will select the ‘First Country Name’ field for the ‘Based on field’ option and ‘First’ for Summarization.
Position the arrow (or widget) appropriately close to the ‘Page Selector’ and copy the set onto every page in the report.
Now users will be able to select which page they wish to navigate to, click on the arrow and Power BI will navigate to the selected page!
That’s it for this week, come back next week for more on Power BI.