Forum Discussion
Filter Visuals with Search Box
I have survey results and need a filter for my visuals so that I can key in a word or phrase and find any comment that contains that word.
I added each question as a separate visual on the canvas so that I can see what each question is with their coordinating responses. Then I added the Filter Box. The problem is if I type in a word like "summer" and there is a survey response in one of the questions/visuals that has that word, it also returns answers for all of the questions in the table row (from that person) even if those answers do not contain "summer".
Hi kmaynard,
According to your descrption, I think this filter effects work as expected. The filter effect should be mapping to other fields based on the current row context relationship key field values.
If you want to custom filter effects, you can create an unconnected table as the source of the filter, then write a measure expression used on the 'visual level filter' to apply filter effect on your visuals.
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng
3 Replies
Please check this https://community.powerbi.com/t5/Desktop/Test-Search-box-multiple-tables-and-visuals/m-p/2185474
Thanks,
Ritesh
Thank you for the suggestion. I won't be able to use a pre-determined search list, though. The search on the visuals needs to be able to handle any random text that the user types in since the survey results are comment boxes. I had merged/concatenated all the columns to use for the Text Finder. Here is an example:
If I type in "teaching" I only want repsonses that include the word teaching. But right now, it shows all answers from the person who used "teaching" in one answer. There are 12,000+ results, so I don't want to read through any results that do not contain the word I'm searching for. Example below of filtered search:
This is how the table is setup:
Hi kmaynard,
According to your descrption, I think this filter effects work as expected. The filter effect should be mapping to other fields based on the current row context relationship key field values.
If you want to custom filter effects, you can create an unconnected table as the source of the filter, then write a measure expression used on the 'visual level filter' to apply filter effect on your visuals.
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng
