Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AndoniA
Regular Visitor

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!

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

 

 

View solution in original post

3 REPLIES 3
AndoniA
Regular Visitor

Thank you very much! It was exactly what i need

Glad to help 🙂

Ritaf1983
Super User
Super User

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

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors