Report builder date range parameter

[jokimwele76]

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?

[heba__abdelshaf]

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

[theonexcent]

Hi,

Kind of late but this worked for me:

=Format(Parameters!YourParameter.value,"yyyy-MM-dd")

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.

[amitchandak]

@jokimwele76 , refer if this can help

Create a date range parameter with Power BI Paginated Reports

https://www.youtube.com/watch?v=v79MjJZoIZg

[jokimwele76]

This does not address my issue unfortunately

[gpiauilino]

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.

[jokimwele76]

Have you found  a solution for this issue?

[gpiauilino]

Hello jokimwele76

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

[sam181818]

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...