This post shows how you can use presentation variables to select a single value in a dashboard prompt and produce a result set that includes a range of values.
Step1: Set a presentation variable with the dashboard prompt.
Step2: Open the Year column in Answers and create the report in this format by giving the SQL Expression and calling the Presentation Variable.
Now the filter Looks like this.
Step3: Dont be panic if we click on Display Results then we will get a error its because we are not passing value to the Presentation Variable.
This can be resolved by placing both the prompt and report in the Dashboard.
Step4: Save the report and place the report and prompt in the Dashboard.