Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

One Slicer to Filter Itemcode in two locations.

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! 

Super User
Super User

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.

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.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors