Forum Discussion
Key Word Search leveraging OR
Hi, Anonymous
According to your description, Text Filter visual can't meet your needs, but you can create a measure and put it in the filter pane to dynamically filter the data selected in the slicer, and there is no need for end users to use the filter pane.
Like this:
Measure =
VAR a =
DISTINCT ( Table2[Slicer] )
RETURN
IF (
COUNTROWS (
FILTER (
a,
CONTAINSSTRINGEXACT ( SELECTEDVALUE ( 'Table'[Column1] ), [Slicer] )
)
) > 0,
1,
0
)
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey
Hi v-janeyg-msft, thank you for responding! This works with the regular slicer but the client is requesting this functionality to be available with a text input. I know you can allow the user to search in standard slicers but it does not work with multiple words.
Hi, Anonymous
Because text filter visual is a custom visual and not official, you can't change its usage at will. Not only did you mention this idea, at least it hasn't been updated until now. Of course, you can try to contact them. Before that, you can also use this workaround to restrict the words entered by the user as a slicer for filtering.
What I gave is just a workaround, and can support multiple choice of words under the action of measure, can’t you understand?
Best Regards,
Community Support Team _ Janey