How can multiple values in the same cell be read separately by Power Bi filter?

[KubenM]

Hello

I have a filter setup for Increment that uses a Fact Table that has the following individual values defined:

Y23PI1

Y23PI2

Y23PI3

Y23PI4

My dimension table reflects that some rows have mulitple Increments in the same cell for example: Y23PI1, Y23PI2 or Y23PI2, Y23PI3, Y24PI4

As my filter only references single Increments, when I filter on Y23PI1 or Y23PI2, Power Bi returns zero as it can't find the single Increments. 

Please assist if possible.

Kind Regards

[amitchandak]

@KubenM , Based on what I got, see if this can help

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c

[KubenM]

Hello

Thank you for taking the time to assist me in this regard.

Another person in this community assisted with a solution in another post that was logged by someone else. So I am happy with the solution he provided. Once again. Thank you.