EDIT 2021-03-02: if you would like to learn how to create a Dynamic Dropdown Navigation – please follow this link: https://businessintelligist.com/2021/03/02/dynamic-dropdown-navigation-in-powerbi/
Dropdown navigation allows us to use the real estate of the report page more efficiently. Traditionally, we use buttons and bookmarks to implement navigation between different pages in our reports, however, as number of pages grows, we eventually start running out of real estate on the page for the menu items. In many other tools, a drop down with different navigation options is used to allow a user chose the destination and then hit Go button to travel there.
We can implement this type of report navigation in Power BI as well. The recipe consists of a lookup table with a row for each page we would like to be able navigate to, a slicer with the values from that table, a button, and a simple DAX calculation to let the button know what page has been selected from the slicer.
Please watch the video below for details:
Our Coronavirus (COVID-19) dashboard is publicly available here: https://bit.ly/2voUAbx
business intelligist 
Thanks very much for this, it’s very informative and exactly what I was looking for. Set something simple up based on your instructions, however when I try to navigate I get and error stating “Unable to navigate to page X. This page may not exist or may not be a valid destination”
The page does exist, I’ve checked that the spelling in the bookmark and the table are identical and that all values are text so I’m not certain what the issue might be.
Do you have any idea what the solution for this may be?
Hi – I’m finding the same issue (in a 50+ page dashboard that desperately needs a better navigation process…)
It seems to be the inclusion of brackets in the page name in my instance; pages without seem to work just fine.
Renaming the pages has to be a last option as they’re using standard naming conventions to match database entries.
Googling to no avail, so hoping you found a solution eventually?
I’m fairly new to PowerBI, DAX and M, so maybe there’s a simple code edit I can implement and i’m probably just not phrasing the search effectively…
Otherwise – great video @BusinessIntelligist
This is great, hope they expand this kind of thing. Makes it much more useful for businesses like mine that use PBI for 3rd party analysis delivered through embedded.
Specifically want to work out how to navigate bookmarks with a dropdown.
Again though this is great, thank you.
Unfortunately, we can’t navigate to bookmarks dynamically yet… Hopefully soon…
Great video, I am using a SSAS tabular model and created my page navigation with my sort there. However when I create the page navigation in PowerBI I am unable to figure out how to sort my Page Navigation for my slide order. Any help would be much appreciated! Thank you!
You have to click on the column holding your page names from the field list, then click on “Table Tools,” then you can choose another column to sort by. My PageNav table has 2 columns, one to hold the page names and the other holds an Index. I click on the column holding the page names and sort it by the Index column.
Hi , I am looking for a navigation without a Go button , if I select the dropdown automatically changes the values .
Thanks & Regards
Shiv
Thank you, everything works but I have to CTRL-click the GO button for it to work. Is this the case or what did I miss?
Nothing. It is set up that way so one click gives you access to the menus so you can format, etc. It’s only ctrl+click when you are editing. Once published to the service a single click will work.