Click in a value from a column of a table that sends me to other page of the report

[Maria_Buzaglo]

Hello,

I would like to know if it is possible (and how) to do the following:

I have 2 pages on my report. At the first one, I have a table visualization that contains 4 or 5 columns. The first column is the "Project ID". So, each line of the table is about one project (each instance of the table is one project). The second report page is about the details of the projects.

What I would like to do is: in the first page, go to the table and click in the project ID that I want and, just by clicking there, the power bi send me directly to the second page filtered by that project ID. 

I though I could use something like URL for the Project ID values and, when I click there, 2 things will occur: change the page to the second one and filter that page just for the project selected in the table of the 1st page, through the use of a parameter that change the value according to what was clicked in the 1st page.

Thanks in advance,

Maria Buzaglo

[amitchandak · Accepted solution]

@Maria_Buzaglo , Drill through should help :https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

New featured added in March 2020 release : https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/

[Maria_Buzaglo]

@amitchandak it worked! Perfect. Thanks. Btw, I used buttons to do it (that new featured added in March 2020). It works pretty well.