Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Report builder date range parameter

I am trying to create a paramater date range in Report builder and i keep getting this error (Query (1, 90) DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.) the column shows its a date / time   when i open the dataset in power BI and even in the database that column shows its date however when i try to use it a parameter date range i get an error . Does anyone have any idea of how to resolve this in report builder?

Regular Visitor

use this video 
Power BI Paginated Reports GOTCHAS! - Part 6 - Date Parameters - Bing video 
will help you to know how to do this.

Frequent Visitor



Kind of late but this worked for me:



I had this problem when tyring to use a field from a DB2 database that was only date and not datetime and again recently when using a Power BI dataset connection as my datasource. What you want to do is use the above formula in the "Parameter Value" field of your desired dataset. Just replace "YourParameter" with the parameter you want to use.  I attached a visual below. Hopefully this helps you out.  @gpiauilino Hopefully this helps you out too.





Super User
Super User

@jokimwele76 , refer if this can help

Create a date range parameter with Power BI Paginated Reports

This does not address my issue unfortunately

I am also facing this problem for a few days.
I can't set my date range to DateTime, and I haven't found a solution yet.

Have you found  a solution for this issue?

Hello jokimwele76

Unfortunately not yet, our team gave up on the project because of this issue. 😞

I have follwed all vedios and google, and it do not work.... The issues is that the dax is hard to understand. The calender date is a date format, but when passing in query it is asking for a text. Vedio all takes the date as date formate but the query is still asking for a text...


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors