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