cancel
Showing results for 
Search instead for 
Did you mean: 

Date Filters Don't Work Properly on Data Section

Hello,

 

When it's selected between two dates (both dates are included), date filter doesn't include the start date. 

 

For example, below I selected "01/01/2020" as a start date and "12/31/2020" as an end date. 

 

senrajh_0-1679325353353.png

While the filter is working for end date, it doesn't work for start date.

End Date

senrajh_5-1679325864815.png

 

---

Start Date

As you can see below there are no records for 01.01.2020

senrajh_3-1679325737879.png

However that's not the case. There are the records belongs to 01.01.2020.

senrajh_6-1679326124614.png

I think "is on or after" doesn't work properly or I'm missing something.

 

Note: On both power query and report section "Date" column selected as Date type.

 

Best Regards.

 

Status: Investigating

Hi  @Anonymous ,

 

I saw the UI in the screenshot you provided and it appears to be a few versions back from Power BI Desktop.
Would you mind updating to the latest version to see if the problem still exists?

 

Best regards.
Community Support Team_ Caitlyn

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @Anonymous ,

 

I saw the UI in the screenshot you provided and it appears to be a few versions back from Power BI Desktop.
Would you mind updating to the latest version to see if the problem still exists?

 

Best regards.
Community Support Team_ Caitlyn

 

Anonymous
Not applicable

Hello @v-xiaoyan-msft 

 

I updated to the latest version, it is fixed now. I wasn't expecting it to be because of this.

Thank you for your help.

 

Best Regards.