Forum Discussion
Power BI button based on selection
I have a BI report of expenses by countries.
I have come up with a first sheet as an Overview, where there is a map with the countries already coloured based on their longitude and latitude, and the relation created.
I have already managed to drill through, but I want to create a button above the map, where based on the selected country, the button changes and when you click on it, it takes you to the sheet of that country.
I have tried to do it with a measure that varies depending on the country: Selected_Country = SELECTEDVALUE(Locations[Country])
The measure goes but I can't get the button to be based on the measure or on the selection, and I wanted to know if it is possible and how to do it.
Thanks!
Hi AndoniA
If I understood you correctly you want to go from a visual point to the filtered by the selected point page it is possible only with a drill-through
if you want to have a button to drill through you can achieve it , please take a look at the linked tutorial:
https://www.youtube.com/watch?v=I7oyyb0Y8Oo&t=8s
Other options to navigate among the pages are page navigator and bookmarks, but it cant work from the visual directly
more information about these options on the linked document:
https://learn.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
3 Replies
Thank you very much! It was exactly what i need
Glad to help 🙂
Hi AndoniA
If I understood you correctly you want to go from a visual point to the filtered by the selected point page it is possible only with a drill-through
if you want to have a button to drill through you can achieve it , please take a look at the linked tutorial:
https://www.youtube.com/watch?v=I7oyyb0Y8Oo&t=8s
Other options to navigate among the pages are page navigator and bookmarks, but it cant work from the visual directly
more information about these options on the linked document:
https://learn.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
