Redirect to the next page by selecting a specific value in the visual

[nik_r]

Hello Experts,

I have two tables in the Power BI Desktop one with import method and another with direct query connection. I have created a visual on the first page with unique IDs of Table 1 and created another page with detailed visuals based on the Table 2. Now, my requirement is to redirect to the next page by clicking on the particular ID from Page 1 and show all the details on 2nd page fro selected ID.

Also to explain in more detail, first table is import mode and if someone needs details they need to redirect to other page(second page has millions of rows of data. So I am preferring direct query). We need to pass the column value as parameter/input to other page. 

I have tried the drill through option, but because the data is available in very large amounts, so the drill through option is not working as expected.

Also find below e.g. for your reference:

Thanks in advance,

[lbendlin]

I have tried the drill through option, but because the data is available in very large amounts, so the drill through option is not working as expected.

Please be more specific.