Forum Discussion
IoannisPhilip
3 years agoAdvocate III
Bookmark Navigation Drop-Down Option
Hi All, I have a tab in my dashboard that I am using to give the option to the end user to benchmark values between preselected years. I did this with bookmarks, which switch between overlying wid...
Dhairya
3 years agoSolution Supplier
Hey IoannisPhilip
According to my interpretation, you have 6 different bookmarks for all 6 Options and bookmark wise all the visuals have different measures used. To have a dropdown list you can use field parameters and use it instead of your base measure and a slicer will automatically be created which you can format as a dropdown list. By doing so you can remove bookmarks and report will also be optimized.
you can follow the below video to get a clear understanding.
https://www.youtube.com/watch?v=-nqEv2YXLsU&t=440s&ab_channel=HowtoPowerBI
If this helps you then please mark my solution as accepted so that others can find this quickly while facing the similar issue. Thank you!