Q&A visual not displaying all rows

[sanjanarama]

Q&A visual is not displaying all of the matched rows with key word, for example if i search with amazon , it only displays one row rather than displaying 4 rows in my data set

Can help me out.

number	customer name	hierachy code	url	customer engagement
100	AMAZON	unified global customer	amazon.com	sales pipeline
1001	aws			amazon
1002	amazon webservice		aws.amazon.com	sales pipeline
1003	wholes food market		www.wholesfoodmarket.com	sales pipeline

[Anonymous]

Hi  @sanjanarama ,

Q&A will only filter if it supports the exact same string.

Can you consider using dax implementation

Here are the steps you can follow：

1. Create measure.

Flag =
IF(CONTAINSSTRING(MAX('Table'[customer engagement]),"amazon") ||
    CONTAINSSTRING(MAX('Table'[customer name]),"amazon") ||
    CONTAINSSTRING(MAX('Table'[hierachy code]),"amazon")||
    CONTAINSSTRING(MAX('Table'[url]),"amazon"),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

[sanjanarama]

@Anonymous 
thank you so much for taking time. how to leverage this solution for any values/strings used in Q&A search visual?? you have only showed result in a table