Power BI: How to Implement Dropdown Navigation

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

7 thoughts on “Power BI: How to Implement Dropdown Navigation

  1. 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?

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

  3. 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!

  4. Hi , I am looking for a navigation without a Go button , if I select the dropdown automatically changes the values .
    Thanks & Regards

  5. 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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s