Forum Discussion

PowerBIUser27's avatar
2 years ago

Project Predecessor and Successor Drill-through - Recursive relationships?

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
ABC
ADE
FBG

 

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!

2 Replies

    • PowerBIUser27's avatar
      PowerBIUser27
      Helper I

      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.