Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.