Major bug in new date filter- Power BI can not be trusted for reporting!!!!

[lcasey]

• When I use the Date LIST format and choose multiple dates I get the correct numbers.
• When I use the Between Date function I get wrong numbers and ALL dates are included. The Date slider simply does not work.

I can no longer trust Power BI tyo accuratly provide reporting.  Please note this is in Direct query mode. Pretty crappy that a so called reporting software has these type of bugs!!!  I cant beleive this software cant work properly with dates.

This is the correct Data displayed when using Date List

THis is the WRONG data displayed when using the New Date Filter

[v-shex-msft]

Hi @lcasey,

I test on power bi desktop(2.41.4581.361 64-bit) and sql server 2016 database("direct query" mode), but I can't reproduce your issue.

Below are result screenshots.

Can you share some detail information to help us to reproduce your issue? For example: power bi desktop version, the table structure, have you used the measures or calculate columns as the value fields...

In addition, you can try to use the newest version of desktop and test again.

Regards,
Xiaoxin Sheng