Forum Discussion

eburke's avatar
eburke
Icon for Helper II rankHelper II
8 years ago

Help needed with filtering

Ok so I have a problem that I think means I've missed something really obvious and simple but I can't see what.  I have three tables:   Data table: Client Name, Employee ID, Task Name, Duration, D...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi eburke

 

Have you tried changing the direction of the relationships from single to bi-directional?

  • eburke's avatar
    eburke
    Icon for Helper II rankHelper II
    8 years ago

    Hi, thanks for that, I tried that but it makes all the numbers disappear.

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Do you have some sample data, or a cut down version of your PBIX file?

      • eburke's avatar
        eburke
        Icon for Helper II rankHelper II
        8 years ago

        Hi I can't post the PBIX file even in one drive our system doesn't allow us to share anything externally.  Here's an example of the data in the table though, the names have been removed for privacy.

         

        Data table:

         

         

        Staff Table:

         

        \

         

        Roles Table:

         

        Relationship:

        Thanks for your help.