Filter 1 Values that is contained in a string

[Anonymous]

Hello Community 
Hoe you can help me with this

So I'm building a dashboard that have a very tricky requirement so that req is that all values that are duplicated concatenate them into a single row for each Invoie 

eg
Invoice 12345 Picker Aaron
Invoice 12345 Picker Janeth
Invoice 12345 Picker John

The result of this will be Invoice 12345 Picker Aaron, Janeth, John
so far this requirement is meet

The issue is that we need to have these values to be able to filter in a filter visual, so user can select one Picker and all the visuals will shoe info related to that Picker

but when doing this instead of showing or keeping the same string concatenated with all the possible Picker it just dissapear and just display the Picker selected

Tehe expetec result will be that the string remains the same and when user select one picker it loks for taht name in the string and displayed complete


For the string concatenation I sue this formula 

CALCULATE(
    CONCATENATEX(
        VALUES('ASN Picker Dematic/Perry'[picker_name]),'ASN Picker Dematic/Perry'[picker_name],", "),
            FILTER('ASN Picker Dematic/Perry',
                NOT(
                    ISBLANK('ASN Picker Dematic/Perry'[picker_name]))))

[amitchandak]

@Anonymous , Please check if Text filter can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

or you can use function

CONTAINSSTRING & CONTAINSSTRINGEXACT: https://youtu.be/Sbqgyjy9Zn4