Forum Discussion
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 ?
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.
2 Replies
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.
Get rid of page 2 to simplify the UX. Use the filter pane.
