Power BI: How to Implement Dropdown Navigation

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

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 )

Google photo

You are commenting using your Google 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