Selected line on page 1 should display the detail values on page 2

[Meeresblume]

Hi there,
please forgive my bad english.

I have a question regarding the following problem:

I created 2 pages in Power BI.
A table can be found on page 1 with all project data (invoice amount, order total, address, etc.) that took place in 2021, for example.
On page 2, the invoices, incoming payments or required hours are displayed in detail in 3 different tables. Accordingly, this is a detailed view of the totaled values on page 1.

Now, when I click / select a line on page 1, I would like the data for this project to be displayed on page 2.
This would work fine within one page. But he's not doing this across pages at the moment.

Is there a solution how to do this?

All tables contain the project number.

Thanks in advance for tips and suggestions 🙂
LG

[jeroendekk · Accepted solution]

Hi @Meeresblume 
I would suggest this could be achieved with a Drill Through page on the project number.
Set up drillthrough in Power BI reports - Power BI | Microsoft Docs

Best regards,
Jeroen Dekker