Forum Discussion
How to set Date Parameters to show data between 2 dates selected from 1 date column
1) Create two parameters
@StartDate (Date/Time)
@EndDate (Date/Time)
Set:
Data type = Date/Time
Allow null = No (or give defaults)
2) Filter the dataset on the single date column
Your dataset already has EntryDate — that’s enough.
In the dataset query filter (or WHERE clause equivalent):
WHERE EntryDate >= @StartDate AND EntryDate <= @EndDate3) If using the Dataset Filters (no SQL)
If your SharePoint List dataset doesn’t expose SQL:
Open Dataset Properties
Go to Filters
Add:
Expression: =Fields!EntryDate.Value
Operator: >=
Value: =Parameters!StartDate.Value
Add another filter:
Operator: <=
Value: =Parameters!EndDate.Value
Super UserYou don’t actually need parameters for this in Power BI — that approach is more common in paginated reports or SQL-based tools. In Power BI reports, the native and best practice solution is to use a date slicer.
Since you already have a single date column (Entry Date), just place it in a slicer and change the slicer type to Between. This automatically gives users a start and end date selector, and Power BI will filter all visuals to show data between those two dates. No extra columns, no query changes, and it works perfectly with SharePoint lists.