Forum Discussion
Filter Visuals with Search Box
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
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