Project Predecessor and Successor Drill-through - Recursive relationships?

[PowerBIUser27]

Hello! I have a simple problem in theory, that turns out to be beyond my expertise in reality.

This involves project data. I have a table called "Projects" with three columns, "Project ID", "Predecessor ID", and "Successor ID". Predecessors are just old projects, and Successors are future projects. So, if Project A has Successor B, that means A must be completed before B. Some projects can be tied to the same Predecessor, or Successor, etc. There is of course much more data in this table, project completion stats and all that, but I'm trying to keep it simple. Example:

Project ID	Predecessor ID	Successor ID
A	B	C
A	D	E
F	B	G

Here's the goal: to have a working Drill-Through where you can right-click either a Predecessor or a Successor, and then see their own respective Predecessors/Successors. The problem: this needs to be repeatable, so I can keep Drilling Through the next table of Project/Pred/Successor, then again Drill Through into either those Predecessor or Successors, as far "up" or "down" the list of projects as I want. Meaning, I somehow have to get Power BI to use both Predecessor ID and Successor ID as a Project ID when I Drill Through. I think.

I tried making separate tables with for Predecessors or Successors, then relating them back to the original Project table, but that didn't seem to work. I'm lost at how to achieve this repeatably. Any ideas are much appreciated!

[v-tianyich-msft]

Hi @PowerBIUser27 ,

Then it seems like you just need to put those three fields into the drill through field on each page.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[PowerBIUser27]

I do wish it was that easy, and that's exactly what I tried first. But that's not the ask here - when I drill through, I want to see that project's predecessors and successors. Including if that project IS a predecessor/successor. So if I'm looking at at simple table, and right-click and drill through on a Project's Successor, I then want to see that successor's...successors and predecessors.

In other words, the Predecessor/Successor columns, when used as filters, need to somehow translate back into "primary" Project ID columns.