Power BI - Users search slicer for keyword and show all items in that column including keyword

[liyuanzhe222]

Hello,

I have a column of task leads. It may include single person (Jason) or several people (Jason, May) . How do i set the slicer so that if user wanna search all the tasks from Jason, they don't need to check all the selections including Jason. Just search Jason and all the tasks Jason leads will come up?

Thanks for all the suggestions! 

[Anonymous · Accepted solution]

Hi  @liyuanzhe222 ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTEDVALUE('Slicer_Table'[Group])
return
IF(
    CONTAINSSTRING(
        MAX('Table'[Task]) ,_select)=TRUE(),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly