How to define Date Range for Parameters in Report Builder
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
