Power BI button based on selection

[AndoniA]

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!

[AndoniA]

Thank you very much! It was exactly what i need

[Ritaf1983]

Glad to help 🙂

[Ritaf1983 · Accepted solution]

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