I'm creating a basic dashboard for work and I can't seem to figure out how to create a query that changes depending on the date that has been selected as a user.

Due to the nature of the business I am not able to share the project file. However I have created a basic one just so you have the gist of what I'm trying to achieve.

Essentially what I'm trying to do is to have the adjust the values depending on the date that was chosen by the user.