Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Lalithya
Frequent Visitor

Navigation

On Page 1, there are visuals, and on Page 2, there are filters and a button. Clicking on that button should navigate to Page 1 only if all the values in the slicers are selected; otherwise, it should display a message prompting the user to select all the filters. How can I achevie this ?

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

Hi @Lalithya 

 

@lbendlin  Thank you for sharing!

 

To achieve this, you need to use conditional navigation in Power BI.

 

This feature allows you to dynamically change the destination of a button based on a field value. Here are the steps to follow:

 

  • Create a table with one column and one row, and enter the name of Page 1 in the cell.
  • Add this table as a single-select slicer to Page 2, and hide it from the user’s view.
  • Select the button on Page 2, and turn on the action option in the formatting pane.
  • Choose Page navigation as the type, and click on the fx button next to the destination.
  • In the conditional formatting dialog, select the table column as the based on field, and enter the message you want to display when the slicers are not fully selected in the default value box.
  • Click OK, and save your report.

When the user clicks on the button, it will either navigate to Page 1 or show the message, depending on the slicer selections.

 

The following links may be helpful to you:

 

Create page and bookmark navigators - Power BI | Microsoft Learn

 

How To: Implement Conditional Navigation in Power BI - Kumo Partners

 

How to Navigate Page in Power BI - Power Tech Tips

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-nuoc-msft
Community Support
Community Support

Hi @Lalithya 

 

@lbendlin  Thank you for sharing!

 

To achieve this, you need to use conditional navigation in Power BI.

 

This feature allows you to dynamically change the destination of a button based on a field value. Here are the steps to follow:

 

  • Create a table with one column and one row, and enter the name of Page 1 in the cell.
  • Add this table as a single-select slicer to Page 2, and hide it from the user’s view.
  • Select the button on Page 2, and turn on the action option in the formatting pane.
  • Choose Page navigation as the type, and click on the fx button next to the destination.
  • In the conditional formatting dialog, select the table column as the based on field, and enter the message you want to display when the slicers are not fully selected in the default value box.
  • Click OK, and save your report.

When the user clicks on the button, it will either navigate to Page 1 or show the message, depending on the slicer selections.

 

The following links may be helpful to you:

 

Create page and bookmark navigators - Power BI | Microsoft Learn

 

How To: Implement Conditional Navigation in Power BI - Kumo Partners

 

How to Navigate Page in Power BI - Power Tech Tips

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

lbendlin
Super User
Super User

Get rid of page 2 to simplify the UX.  Use the filter pane.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors