Forum Discussion
Multiple Slicers filtering 2 tables when only one active relationship can be set
Looking for some help with a problem I have that I have seen some community posts that I tried to no avail. Thank you ahead of time! Have 3 tables - OPPTY, DATE, QUOTA DATE Table(not shown in p...
eegarlepp - It looks like your problem may be the bi-directional relationship between opp and quota. Does it need to be bi-directional?
Cheers!
Nathan
Thanks Anonymous for your response. In the model are set the direction of those 2 tables from Both, to single and back and nothing. Below is how the relationship of the 2 tables is setup. The cardinality has to be Many to Many due to how the Quota table was created which was by way of unpivoting the original table.
Hope this helps...