Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Input
| Week_ID | Period | Item | Value |
| 1 | Pre-Pilot | A | XXXXX1 |
| 2 | Pre-Pilot | A | XXXXX2 |
| 1 | Pre-Pilot | C | XXXXX3 |
| 3 | Pre-Pilot | D | XXXXX4 |
| 3 | Pre-Pilot | A | XXXXX5 |
| 4 | Pre-Pilot | B | XXXXX6 |
| 5 | Pre-Pilot | B | XXXXX7 |
| 5 | Pre-Pilot | A | XXXXX8 |
| 4 | Pre-Pilot | C | XXXXX9 |
| 6 | Pilot | D | XXXXX10 |
| 6 | Pilot | A | XXXXX11 |
| 7 | Pilot | A | XXXXX12 |
| 8 | Pilot | D | XXXXX13 |
Select Week_ID for Pre-pilot 1,2,3,4,5 and Pilot 6 from two seperate slicers.
Requirement
I need to create a single table values for Pre-Pilot selected period ( 1, 2, 3, 4, 5 ) for only items ( A, D ) which selected within Pilot period.
Can anyone advise how can I create below output according to the above requirements.
Output
| Week_ID | Period | Item | Value |
| 1 | Pre-Pilot | A | XXXXX1 |
| 2 | Pre-Pilot | A | XXXXX2 |
| 3 | Pre-Pilot | D | XXXXX4 |
| 3 | Pre-Pilot | A | XXXXX5 |
| 5 | Pre-Pilot | A | XXXXX8 |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.