Forum Discussion

mdex's avatar
mdex
Resolver I
6 years ago
Solved

Multiple Relationships

I'm new to PBI and I'm having issues with Active/Inactive relationships and I cannot figure a way around it.  I have 2 tables,

 

Time Booking

NameTeamIDHoursPGLHoursWeek_Number
Bob15543
James22443
Gary13243

 

Report Data

TeamIDAnalystsHoursWeek_Number
1512043
2720043

 

The tables are currently linked via the TeamID. When I'm creating reports from the 2 tables I need to slice using both TeamID and Week_Number. From what I can tell it isn't possible?

Need Help
  • Asac_14's avatar
    Asac_14
    6 years ago

    Create two Dim tables one for Unique TeamID and one for Week_Number and connect these two tables to the Dim table. use the Dim table for slicers. Do accept this as solution if this solves your problem.

     

    Thanks & Regards,

    KK

2 Replies

  • Asac_14's avatar
    Asac_14
    Resolver I
    6 years ago

    Create two Dim tables one for Unique TeamID and one for Week_Number and connect these two tables to the Dim table. use the Dim table for slicers. Do accept this as solution if this solves your problem.

     

    Thanks & Regards,

    KK