How to do Page Navigation using Slicer and a Button (without bookmark) in Power BI?

Table of Contents

 

Page Navigation is an important part of the report as it makes the report more interactive. Previously, We used to achieve page navigation in a report using a bookmark and it was not possible to do the same using slicers and a  button. After the March 2020 Power BI Update, It is possible to do page navigation using a slicer and a button.

So Let` see How to do Page Navigation using Slicer and a Button (without bookmark) in Power BI? In the Microsoft Power BI March 2020 update, New feature Page navigation has been added in the Action property in which you can directly specify the page which you want to navigate through the button or you can use conditional formatting using fields (DAX) to make page navigation more dynamic.

 
 

Initial Preparation for Demo

 
 
In this section, We will describe the method to create the initial components required for the Demo.
 
 
1. Create Pages for Navigation.
 
 
 
 
 
 
2. Create a Table with a Column having Page Name as Value.
 
 
  • Click on Enter Data in the Home Ribbon.
 
 
  • Enter the Page names in the Column Page Name. Make Sure there is not typo mistake, exact Page names should be entered. See the below Image. 
 
 
 
3. Create a Slicer for Page Name Column.
 
 
4. Create a button
 
 

 

 
 

 

 

Demo Solution Steps

 
 
 
Let`s see all the steps for achieving the Page Navigation using Slicer and a Button.
 
Steps1: First we have created a measure for capturing the value selected in the slicer.  Let`s see the Dax expression below.
 
 

Selected Page =
SELECTEDVALUE ( ‘Page Table'[Page Name] )


Using the SELECTEDVALUE Dax function, we are capturing the page name selected using the slicer.


Step2: Create another measure for showing the page to be navigated in the button text. 


Button Name =
“Go To “ & [Selected Page] & ” Page”


Step3: Now we have to use the measure created in the above steps. We will use the Button Name measure to do conditional formatting using fields in the Button Text Property. This will ensure that the selected page name in the slicer gets displayed in the button text.

  • Click on the Conditional formatting button in Button Text Property.

 

 

 

  • Once you click on the fx button below the Button Text Option. Pop up window will open where the option to select the measure will be provided which will show the page name in the button text based on page name selection in the slicer.
 
 
 
  • Now we will go to the action property of the button. In the type option, select the Page navigation. In the Destination option, Click on the fx button to use the conditional formatting option using field value.
 
 

 

  • You will get the option to select the measure Selected Page which will provide the page name to which navigation has to be done.

 

 
 
 
 
 
Now everything is done to achieve the page navigation using a slicer and a button. You can now select the page and then click on the button to navigate to the selected page.
 
 
 

Final Thoughts


You learn through this article How to do page navigation using a slicer and a button. Well, you can do page navigation using the old method of using a bookmark but in that method, you will require a lot of buttons equal to the number of pages used for navigation.

So, it basically depends upon the client’s requirement which method to be used for page navigation.

Using the same concept you can also perform dynamic multiple column selection

Categories
quick-report
Power BI Desktop
Kaushlendra Mishra

How to create a report quickly in Power BI Service?

Do you want to create a quick report in Power BI? The latest Power BI version has made it possible to create a quick report using data from the web and existing published datasets in Power BI Service. So, now you do need to download the Power BI Desktop software into your PC and directly make a report using the Power BI service.

Read More »
WHAT IS AVAILABILITY SET & AVAILABILITY ZONE
Azure
Kaushlendra Mishra

What is Availability Set and Availability Zone in Azure?

What is Availability Set and Availability Zone in Azure? In Availability Set, VM`s copy is created and is isolated with separate physical servers, computer racks, storage units, network switches in a data center within a region so if one of the VM stops working then still we have the copy of the VM working within the same datacenter. While Availability Zone ensures that complete datacenter data is replicated to another place at a distance within the same region so that even if complete data center fails due to any reason then also Availability of data is ensured.

Read More »
prepare-DP-200-exam
Azure
Kaushlendra Mishra

How to Prepare for DP-200 Exam?

I have passed the DP-200 exam on 28 Oct 2020. I have gone through the various study material and courses in order to prepare for the exam. Overall, the time taken by me for the DP-200 exam is approx 3 months. Ideally, you should not take 3 months of time but due to lack of guidance, I happen to take a number of online courses which was not required to be taken for passing the DP-200 Exam.

Read More »

Leave a Comment

Your email address will not be published. Required fields are marked *