Reply
avatar user
Anonymous
Not applicable

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 @Anonymous 

 

@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 @Anonymous 

 

@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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)