Forum Discussion

Imagauthamam's avatar
Imagauthamam
Helper III
2 years ago
Solved

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

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 ...
Need Help
Show and Tell
Tips and Tricks
  • dk_dk's avatar
    dk_dk
    2 years ago

    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 🙂

dk_dk's avatar
dk_dk
Super User
2 years ago

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 🙂