Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi everybody
If a referenced project ID exists in the table, I want to drillthrough on the referenced project id (in a second report page).
Expected result:
In the report page 2 I want to see the information of the referenced project and not of the original project (row 1 in the table in report page 1).
Current Status: I used the filter 'Referenced project ID' for all visuals in report page 2. But I still get the information of the original project instead of the referenced project.
I believe I have to match 'project ID' and 'Referenced project ID'?
Thank you in advace for your support.
Greetings
Can you share your pbi file ?
Hi @freginier ,
Unfortunately I cannot share the file for confidential reasons. I have recreated the two report pages in the screenshots.
On the report page 1, you'll find a table with the 'project id' and the corresponding project details such as 'project name', 'project start and end date', 'cost', 'project stage'. Some projects (rows) have a 'referenced project id'.
On page 2, you should see the project details of the 'referenced project id'. I want to drill through in page 1 by 'referenced project id' to report page 2. In the visual (table with 'project name', 'project start and end date', 'cost', 'project stage') in report page 2 I keep ONLY the filter for 'referenced project id. The project Id is not in the list of drill through in page 2.
What information or settings do you want to check in the pbi file?
Greets
User | Count |
---|---|
3 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
4 | |
3 |