Forum Discussion
1001
Resolver II
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...
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.
FreemanZ
Super User
Super Userhi 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