cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kandarp
Helper I
Helper I

Format page navigator or bookmark navigator as dropdown.

I have few pages in my report. I am trying to show them as dropdown using page navigator but there is no as such option.

I want to implement this, withiout any search button and directly on dropdown selection. 

How to do that. Please help.

1 ACCEPTED SOLUTION

Hi @Kandarp 

 

The slicer visual can only let you make a selection but it cannot set up an action for page navigation, so I think this is not possible without a button. The button is for the page navigation action. 

 

Best Regards,
Community Support Team _ Jing

View solution in original post

6 REPLIES 6
pratyashasamal
Solution Sage
Solution Sage

Hi @Kandarp ,

  1. On the Home tab, select Enter data.

    The Create Table dialog box opens.

  2. In the Create Table dialog box, enter the names of your pages in the column. Power BI uses an exact string match to set the drillthrough destination, so ensure that the values you entered exactly match your drillthrough page names.

     
  3. After you've created the table, add it to the page as a single-select slicer.

Create a page navigation button and select the conditional formatting option for the destination:

  1. Under Style, set Action to On, and then expand Action. Select Page navigation for Type, and then select the Conditional formatting (fx) icon next to the Destination.

  2. On the Destination - Action page, select the name of the column you created. In this case, it's Select a destination.

     

    Now the button can navigate to different pages, depending on the user’s selection.
    You can also follow this link :-
    https://learn.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop


    Thanks ,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C
Dhairya
Solution Supplier
Solution Supplier

Please refer to below link this may help you!
https://www.youtube.com/watch?v=ER9F3sHdqiY

Please mark this reply as as accepted solution if it helped you!

Thanks @pratyashasamal @Dhairya for the reply. 

 

After going thorugh solution provided by you, it seems I have to add one extra "search" button along with dropdown. 

My requirement is to navigate between pages whatever I select directly in dropdown and without having any extra click on button. 

 

For an example from below screenshot, 

Kandarp_0-1686030190983.png

If I select option Page 1 from dropdown, it should immediately redirect me to Page 1. If I select Page 2, it should redirect me to page 2 without any extra click on button.

 

Please let me know if it is possible. 

Hi @Kandarp 

 

The slicer visual can only let you make a selection but it cannot set up an action for page navigation, so I think this is not possible without a button. The button is for the page navigation action. 

 

Best Regards,
Community Support Team _ Jing

Hi @Kandarp ,
You can follow this link to add search button for your drop down
https://www.google.com/search?q=search+button+along+with+dropdown+in+power+bi&rlz=1C1GCEU_en-GBIN101...

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

@Kandarp  Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors