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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
s3004023
Frequent Visitor

Drillthrough on the referenced id in a column table

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).

s3004023_0-1675521027069.png

 

Expected result:

s3004023_1-1675521208563.png

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. 

s3004023_2-1675521501118.png 

s3004023_3-1675521690785.png

I believe I have to match 'project ID' and 'Referenced project ID'?

 

Thank you in advace for your support.

 

Greetings

 

3 REPLIES 3
s3004023
Frequent Visitor

@freginier 

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)?
 
Thank you in advance.
freginier
Solution Specialist
Solution Specialist

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 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.