Optimizing Text Search

[Imagauthamam]

Hi All,

I have a dataset around 50K rows and there is a column called "Description" which contains an average of 700 rows per record.So each record will have a long text. 

So I dragged a table visual and dropped this column into the table.
Then I went into filter pane and I filtered "description" column with Contains filter and I gave a random keyword like "access" and tried to filter the table.
It takes 12 seconds for the visual to load the results even though I'm using Import Mode.
Is there a way that I can improve the performance so that it loads within 2-3 seconds.
It is shocking for me even the default filter pane is taking more than 10 seconds to load.
When we query this in our data source(GCP) using a SQL query it loads within 2-3 seconds.
So Is there a way for me to improve the performance and reduce the loading time in Power BI

[Imagauthamam]

Thanks @amitchandak  for the response.
I have tried text slicer visual also. 
But there are 2 issues:
1. When I type in a keyword, it takes more than 15 seconds to load because each record has minimum 600 words because its a call center conversation data

2. When I publish this in Power BI Service, the text slicer visual itself takes lot of time to load because the column contains so many words.

I was just thinking if we could reduce the load time from 15 seconds to 5 seconds.
If this is something that Power BI Cannot do we need to look at some other options.

Let me know your thoughts @amitchandak 

[amitchandak]

@Imagauthamam , Are you using text filter slicer?

If not try that

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE