Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Name | TeamID | Hours | PGLHours | Week_Number |
Bob | 1 | 5 | 5 | 43 |
James | 2 | 2 | 4 | 43 |
Gary | 1 | 3 | 2 | 43 |
Report Data
TeamID | Analysts | Hours | Week_Number |
1 | 5 | 120 | 43 |
2 | 7 | 200 | 43 |
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?
Solved! Go to Solution.
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
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
Thanks KK
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |