Filter

Hi,

Please try to duplicate the original column and use 'Split Columns' function to split duplicated column in Query Editor:

After Apply&Close, create a Slicer table:

Table 2 = DISTINCT(UNION(SELECTCOLUMNS('Table',"A",'Table'[Sales Manage - Copy.1]),SELECTCOLUMNS('Table',"B",'Table'[Sales Manage - Copy.2])))

Then create a check measure:

Measure = IF(SELECTEDVALUE('Table 2'[A]) in FILTERS('Table'[Sales Manage - Copy.1])||SELECTEDVALUE('Table 2'[A]) in FILTERS('Table'[Sales Manage - Copy.2]),1,0)

Apply this measure=1 to the visual, when you choose a name in slicer, the result shows:

Here is my test pbix file:

https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-gizhi_microsoft_com/EaRtvIw6e5tMnwQaqwfraOIBaxH7z7CvTaFsqucUggp9jA?e=A9G0cP 

Hope this helps.

Best Regards,

Giotto Zhi