Advanced Search within Table Visual

[Matt_Mohawk]

Hi,

I am trying to figure out how to search through a table visual for a specific value. The company I work for wants to be able to to keep count of how many times a yarn is used within a given timeframe. I have a Text Search field that will allow me to search for any given value that is entered into the search visual as well. I am not sure what I need to do in order to perform this action. In the pictures I am showing how the data is laid out in Power Query and another picture shows the search field in the top right section of the database and the table that contains the data that will displayed once it finds the correct search criteria.

Any help is appreciated

[Matt_Mohawk]

@VijayP ,

I have to make sure that the Table view shows up exactly like I have in the 2nd picture. If I unpivot it will put everything to a single column. Would I need to duplicate the table that contains the yarn data and then link the 2 tables together?

[VijayP]

@Matt_Mohawk 
My suggestion is bring all columns (Yarn codes) in single columns using unpivot in Power query
in Power bi report view create slicer all yars and then select any sepecific yarn and you should be able to see the list of specific yarn. For that you donot require a serach box separately. Slicer will do!