I can't get my date filters to work inside power bi report builder

[PowerUser3]

Hello,

I have been trying numerous times to get a date parameter to pass in my power bi report builder report. My date passes as date time initially and then I've adjusted to just date in Power Query in main dataset. Created a parameter in main dataset with same data type (date). Create another dataset that is derived from the main dataset, that just pulls dates from the dataset. I then change the data type on that date field to just date. Then I created a parameter that uses the values from my subset of data of just the date column. After, I then go the dataset properties - parameter in the main data set and set up a parameter for date, and using the drop down select my parameter. Then when I run the report all blanks show and no data shows up. I even tried turning the parameeter into date format in the expression field on the parameter window.

I'm not sure why this isn't working.

[Anonymous]

Hi @PowerUser3 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[Anonymous]

Hi @PowerUser3 ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[Anonymous]

Hi @PowerUser3 ,

Thank you for reaching out to the Microsoft fabric community forum.

I understand you’re trying to get your date parameter to filter data in Power BI Report Builder, but the report is returning blanks. This typically happens when the parameter’s data type or format doesn’t exactly match the dataset field or when it’s not correctly linked in the dataset query. To resolve this, ensure the date field in your main dataset is of type Date (or converted to Date in the query) and that your query filters on the parameter directly, for example: 

WHERE CAST(DateField AS DATE) = @ReportDate

Create a second dataset to return distinct dates for the parameter dropdown, set the parameter’s data type to Date, and in Dataset Properties → Parameters link the query parameter to your report parameter exactly by name. Also, avoid formatting the parameter in expressions use raw date values for matching. The screenshot below shows the correct linking between datasets and parameters, which should make the filter work as expected.

Hope this helps. Please reach out for further assistance.

Thank you.

[PowerUser3]

I only have the issue for date/time not just date in the drop down for parameter properties: 

[Anonymous]

Hi @PowerUser3 ,

I understand your concern, in Power BI Report Builder, the parameter type can only be set to Date/Time, there isn’t a separate “Date-only” option in the parameter properties. That’s why you only see Date/Time when configuring your parameter. To achieve the behavior you want, the recommended approach is to keep the parameter as Date/Time but control what’s passed and displayed:

• In your available values dataset, return only the date portion of your field (for example, using CAST(DateField AS DATE) in SQL or converting to Date in Power Query). This ensures the dropdown displays just the dates without time.
• In your main dataset filter, explicitly cast the field to Date when comparing, e.g., WHERE CAST(DateField AS DATE) = @effdate.
• If you want the dropdown to display a clean date format (e.g., MM/dd/yyyy), set that in the “Label field” of the parameter setup.

This way, users will see and select only dates in the parameter dropdown, even though Report Builder handles it internally as Date/Time.

Since Report Builder currently doesn’t provide a true “Date only” parameter type, you may also want to share this suggestion in Fabric Ideas - Microsoft Fabric Community so the product team can consider adding native support for Date-only parameters in future releases.

Hope this helps. Please reach out for further assistance.

Thank you.

[Anonymous]

Hi @PowerUser3 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.