Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Drillthrough on the referenced id in a column table

Hi Experts,

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.



Frequent Visitor

@amitchandak Is there a smarter way than replicate the table 1, match the table1[PROJECT ID] with table2[Referenced project ID]  and drillthrough on measure = SELECTEDVALUE(table1[Referenced project ID],1)?

Hi, sorry to revive this, have you ever resolved this? If so, mind to share some logic here please? Thank you

Super User
Super User

@s3004023 , Hop project Id is not in the list of drill through?



Power BI Drill Through - More than one level:


Hi @amitchandak,

Unfortunately, the video was not helpful as it described how to drill through on a previous drilled through.


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.


Why do I still see the project details of project id instead of referenced project id?



Hi @amitchandak 


Thank you for your fast answer. The project Id is not in the list of drill through in page 2. In the report page 2 (drill through) you can find the 'referenced project ID' and columns like 'project name', 'project start and end date', 'cost', 'project stage'. Unfortunately the values of project id are returned in the drill through page, instead of the corresponding values of  'referenced project ID'.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.