Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Range (inclusive) Operator issue in Report builder

Hello all,   New to Power BI and learning something new everyday. I am having an issue when i use the range inclusive operator in the Report builder. I created a dataset in Power Bi desktop with ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    According to the information you provided, for this type of error it is caused by a wrong setting of the field's type. The values to be compared need to have the same data type.

     

    You use Format function to change the data type or just the date type on the desktop menu.

    For example:

    Column = FORMAT('Table'[Date],"yyyy-mmmm")

     

    related document link:

    Power BI Date Formatting | How to Change Date Format in Power BI? (wallstreetmojo.com)

    Using the Field list in Power BI Desktop - Power BI | Microsoft Docs


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ShaunFenchel's avatar
ShaunFenchel
Regular Visitor
3 years ago

I am having the same issue.  I have a date field formatted as a date in my Power BI Dataset.  When I build a query using the date field and use "Range (Inclusive)", I get this same issue if the parameter is formatted as a date/time.  If I change it from "Range (Inclusive)" to "Equals", it will work with the parameter formatted as a date/time.  I want the parameters formatted as date/time so the calendar picker is available, but it will not work with a range.