Forum Discussion
Resolver IIUnable to Filter Across Three Tables
Hi All,
I have a series of tables, each connected through a common Unique ID Number.
However, from the diagram below, I am trying to use a filter (Shelf Life) from my ZPLAN table to filter Products containing ShelfLife in the ZSLED table, but the relationhsip isn't working. Just wondering if anyone had any pointers? Many thanks.
Thanks for your help all,
I ended up cheating, deciding to save the Existing Excel Pivot Table including related column formulass, as 'values only' to a new sheet as that day's date. Then I imported those daily files into PBI and consolidated them into one single table. Everyhting's now outputting as I need.
Cheers.
4 Replies
- pratyashasamal
Memorable Member
Hi 1001 ,
Please try to make the relationship between Masterdata and ZSLED Prior Week Table to bidirectional .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C 
1001Sorry Pratyashasanal,
not working. I think the issue is I may have to create a unique Shelf Life number table that feeds into ZPLAN and use that as my filter. Will try that.
Thanks.
FreemanZSuper User
hi 1001
The relatiinship between ZPLAN and ZSLED is many-many. You can try to set the cross filter direction between Master and ZSLED as Both. See if it works.
If that doesn't work, try check this
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships
- 1001
Thanks for your help all,
I ended up cheating, deciding to save the Existing Excel Pivot Table including related column formulass, as 'values only' to a new sheet as that day's date. Then I imported those daily files into PBI and consolidated them into one single table. Everyhting's now outputting as I need.
Cheers.
