One Slicer to Filter Itemcode in two locations.

[CalebR]

Hello,
So I already have my data model laid out and Im having an interesting issue. Youll see I have two slicers for ItemCode in the top left. This is because my highlighted table at the bottom looks at the recent purchase orders for selected item code. I originally just had one slicer to select itemcode from my ItemWarehouse table, but it then caused the measures in that bottom table to not work properly since itemwarehouse is not directly related to that purchaseorder table. Due to this I had to add another slicer that filters the itemcode in the purchaseorder table as well. 

Is there a way to create a sort of master-slicer? That way a user who uses this dashboard doesnt have to select the same item code twice?
Im not sure if seeing my data relationships help but here they are with the tables where itemcode is coming from 

Thank you in advance for any help/ideas you have! 

[lbendlin]

I don't see a data model. I see a bunch of tables connected in inventive ways 🙂

Rethink your data model. Identify dimension tables and fact tables. Avoid bidirectional joins unless absolutely required.

[CalebR]

I dont know what you mean but I got it figured out, just connected PurchaseOrderDetail directly to CI-Item where the other item code was and it works just fine.