How to define Date Range for Parameters in Report Builder

[Rachel_123]

Hi,

I have a request to have a date range filter based on submission date in a paginated report, I am able to create the date range and it's working, however the report has only 3 years worth of data and the date range showed in filters displays all possible dates from 1800s, so users can select older dates although there's no data for those dates. I am trying to limit the date range filter to the relative dates in the dataset but I can't figure a way to do that.  My paginated report is connected to a PBI dataset so I am using dax.

This is my query

-----------------------------------

DEFINE

MPARAMETER s_start_dt = FORMAT(@s_start_dt, "MM/dd/yyyy")
MPARAMETER s_end_dt = FORMAT(@s_end_dt, "MM/dd/yyyy")

VAR __Table1 =

SUMMARIZECOLUMNS(
Query1[Category],
Query1[Aggregate Underwriting Comp],
Query1[violation_id_link],
FILTER(VALUES(Query1[sbmsn_dt]),Query1[sbmsn_dt]>= @s_start_dt && Query1[sbmsn_dt]<= @s_end_dt)

)

EVALUATE __Table1
ORDER BY Query1[sbmsn_dt] desc

--------------------------------------------------

the parameters are defined as Date/Time with no available values nor default values

Below is a screenshot of how I see the date rnage right now, any help would be appreciated!

I have also tried the usual way where I add a calendar data source with relative dates (min and max based on my dataset), but this displays 2 boxes in the report for "From" and "To" Dates with dropdown to choose the date (like a dropdown text) which is not very intuitive