Return certain values in column based on a selected column from another table

Question

Hi,&nbsp;&nbsp;I'm trying to return certain values in a column based on a selected business unit.&nbsp;&nbsp;The business units have several products, but its only certain products and their weight that I'm interested of.&nbsp;&nbsp;Firstly, I have created a measure for each unit and their products and weights.&nbsp;&nbsp;Production (SOUTH) = CALCULATE (&nbsp; &nbsp; [WEIGHT(KG)],&nbsp; &nbsp;KEEPFILTERS(DIM_BU[Buid] = "SOUTH"),&nbsp; &nbsp;KEEPFILTERS(DIM_PRODUCT[PRODUCT] IN {"Banana","Apple","Pear"}))&nbsp;Then I have created a SWITCH&nbsp;Production Switch = &nbsp;VAR&nbsp;BU&nbsp;= SELECTEDVALUE((DIM_BU[Buid]])&nbsp;Return&nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; True(),&nbsp; &nbsp; &nbsp; &nbsp; BU= "SOUTH", [Production (SOUTH)],...)&nbsp;&nbsp;In my report I have a slicer for the BU but i also want a slicer that only displays the selected product of the chosen BU, for all BU.&nbsp;&nbsp;So if I chose BU south in the slicer I only want the selected products for that BU to appear in the products slicer. &nbsp;How do I do this?&nbsp;

vicky_ · Answer

If 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.

sljn · Answer

Thank you.&nbsp;There is a relationship.&nbsp;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.&nbsp;I want the user to be able to change BU and only get the products specified for that specific BU in another slicer.&nbsp;&nbsp;

Forum Discussion

Return certain values in column based on a selected column from another table

2 Replies

Related content

slicers automatically selected based on another slicer selection

updating one tile based on selection in another tile

Selecting rows based on the ranking from another table

Make a field parameter slicer that adjusts according to another field parameter's selected value

Change or switch slicer selection based on another slicer?