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?
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?