Dinamic Queries in Quick Sight

Hi Community,
I want to create a report depending of user input parameters, I know quicksight has direct queries. But I need make the where statements of the query dynamic or dependent of filter selection of the user.
so every time the user select a date in the report, the query calculate again the dataset.
any thoughts? or another AWS solution to achieve this kind of dynamic reports?
Cheers!

you seem to be looking for a solution like this one Ask the Experts: Parameters with Amazon QuickSight - YouTube