Getting User input and filtering the data using Dynamic M query Parameter

[Imagauthamam]

I have a requirement wherein I have to get a user input and that value should be filtered in a column so that it filters the whole table and gives a summary of the total number of cases by that User Input.

Let me give an example.

Consider I have the below data:

Then I have to give a search bar like the below and let's say the user types "Access", then I should get the below output:

It should take that user input and filter the description column using that word.
Then it should group by the day level and give the total number of cases which contains that keyword.

What I thought was there must be some way in which we can get the user input and stored in a parameter and then using Dynamic M query I can filter out the table using any keyword that user inputs and give them the total cases by day level for that Case.
But how do I take the user input and pass it into a parameter? I'm not sure. 
Any help would be much appreciated!!!

[Imagauthamam]

Thanks @dk_dk for the suggestion.

[dk_dk · Accepted solution]

Hi @Imagauthamam ,

Would it work that you simply create a table with the date and Description count measure, and then add a filter on the description field to the filter pane and set it to Advanced filtering with a contains condition like so:

Alternatively. the Text filter custom visual from Microsoft also should work, and that you can place on the canvas as a slicer. Maybe better user experience than the filter pane?

I hope this helps 🙂