cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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?

1 ACCEPTED SOLUTION
Resolver I
Resolver I

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

View solution in original post

2 REPLIES 2
Resolver I
Resolver I

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

View solution in original post

Thanks KK

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors