Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 101 | |
| 76 | |
| 56 | |
| 51 | |
| 46 |