Forum Discussion
Solved
How to set Date Parameters to show data between 2 dates selected from 1 date column
Hello, I wanted to set up a parameter for users to select a date range and generate a report showing data in between the selected dates. I have looked up videos/previous posts about this and all su...
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
Murtaza_Ghafoor
Super User
Super UserHow to let users select a date range in Power BI (SharePoint data)
- Create a Date table in Power BI (using DAX).
This table will contain a list of dates. - Link the Date table to your data
Create a relationship between
DateTable[Date] → YourList[Entry Date] - Add a Date slicer to the report
Use DateTable[Date] in a slicer and set it to Between. - Users pick start and end dates
The report automatically shows only records where
Entry Date falls between the selected dates.
Key thing to remember
You do not need start or end date columns in your dataset.
A single Entry Date column is enough.
This approach works perfectly with SharePoint Lists and does not require Query Designer or Power Query parameters.