A slicer or dropdown to return values where the selected value is found within

[Mllam]

Hi Everyone,

I have been doing my research and have brought a table close to where it needs to be in power query.

The last thing I need to know is if the following is possible. I am struggling to find a solution to this:

Assumption: These distributor names need to remain concatenated.

Question 1: Is there a way to select 'Name1' in a slicer or dropdown and return only results on the right that contains 'Name1'? I tried looking into LAMBDA but just couldn't get it right.

Question 2: If yes to question 1, would the solution also work for a pivot table?

I appreciate your attention on this.

Thank you,

M

 

[t0ny84]

Hi Mllam,

I have done something similar using "helper" column(s). This is an additional column that you use with the drop down / slider.

You just need to work out the logic.

Example:
Move the table down a row and add a column. For this example we will call it NewCol which is in column B and the cell in the new row we added above the table is B1.

In cell B1 put
=Cell Where Drop Down Is Located


In the NewCol put
=SEARCH($B$1, TableName[@Distributor])

This will search for the Distributor Column Cell for that row and look for the value of B1.

You can then use the slicer from here to get results that include your specific distributor.

Further Information on Helper Columns