Forum Discussion
Return certain values in column based on a selected column from another table
Super UserIf there is a relationship between BU and Products (e.g. they are in the same table or there is a bi-directional relationship between their tables), check to see that visual interactions is enabled between the two slicers.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop
Or you can use a BU > Product heirarchy and just hiding the specific BU / products that you aren't interested in.
Thank you.
There is a relationship.
however there's a lot of BU and they all have specific products that I'm interested in. This solution is dependent on me editing, I'm looking for a more scalable solution.
I want the user to be able to change BU and only get the products specified for that specific BU in another slicer.