Forum Discussion

Ximo's avatar
Ximo
Frequent Visitor
4 years ago
Solved

Working with Project Online lookup table multivalue hierarchical structure

Hi all, I am working on a Power BI slicer to filter projects depending on the department. The Lookup table from Project Online is:     For this Departments field (not the OOB Department fro...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I tried tinkering with this some. See if the attached helps at all.

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I tried tinkering with this some. See if the attached helps at all.

 

  • Ximo's avatar
    Ximo
    Frequent Visitor
    4 years ago

    You got it!!

    I added the bidirectional on Projects/Fact and Departments/Fact relationships:

     

     

    And now it is filtering the projects with that department:

     

     

    Thanks so much AlexisOlson!! 💪💪💪