Forum Discussion
Wrong Filter Flow Direction when using Excel Power Pivot
Hello everyone! I am having a problem which is doing my head in. So in the file attached, you can see that I have a table for Package, a table for Arenas (Products), and a table of which arena...
Robin_Lindstrom Use the ArenaCode from the Arena_Package table in stead of the Arena table. I believe that gives you what you need. Two packages showing the Arenas that are included in each of them. See attached.
- Thank you Riny!
In PBI, you can set the filter direction to bi-directional but that does not seem to be the case in Excel Power Pivot? Eventually, I want to build a bigger model but I am unsure if that will work in Excel if the filtering direction only goes one way. Do you have any experience regarding this?
