Create a custom button to link between report pages and use filter context

[Anonymous]

We have a report with information on members of Congress. One page lists all members and their high-level information. See below.

Our customers want to be able to click on the member's picture (or maybe a button somewhere in that row) that will take them to the page with all information about the member. See below. 

Is there a DAX statement that will dynamically set a filter on a separate page based on a field clicked on another page?

Hopefully this makes sense. 😀

Thanks for the help!

[MFelix]

Hi @Anonymous ,

You must use the drill trough option that allows to donit based on rigth click or creating a button to do it.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[Anonymous]

I tried that, but the page I want to drill through to has a single select slicer that defaults to a member in the Senate. When I did the drill through, it took me to the page, but all visuals were blank. Any other ideas?

[MFelix · Accepted solution]

Do a new page without the slicer and hide it on the report view, also create a back button. That way the users don't know that they are being redirect to another page

[Anonymous]

Worked great. Thanks!!