Forum Discussion

maltamar's avatar
maltamar
Frequent Visitor
2 years ago
Solved

Report Builder Date Range (inclusive)

Hey,
I have the following issue with the date range (inclusive) parameter in PBI Report Builder,

I have the query set up correctly, i have followed the guidelines from this video and the report runs well
BUT
the selected date range is not being inclusive, it only takes the FROM date as the date filter and not the date range between those dates.

How can i fix this?

 

 

 

 

 

 

  • Hi maltamar ,

     

    From your description, it seems that you've set up everything correctly but the date filter is not capturing the entire range as expected.
    If the query seems correct, please check the data type of the date fields in the dataset to ensure they are indeed date types and not datetime or other types which could affect the filtering.

     

    Best Regards,
    Yulia Yan

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

1 Reply

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Icon for Community Support rankCommunity Support

    Hi maltamar ,

     

    From your description, it seems that you've set up everything correctly but the date filter is not capturing the entire range as expected.
    If the query seems correct, please check the data type of the date fields in the dataset to ensure they are indeed date types and not datetime or other types which could affect the filtering.

     

    Best Regards,
    Yulia Yan

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