I have created a brand new, very simple data model with a single table "Sales Invoices". This table is sourced from the business central connector.
*I experienced this issue in a much larger model, but have created a new one to ensure the issue is not caused by anything else in the model.
If I then create a table visual and place the quantity field, it will give me a summary of the quantity for the whole table. Everything looks good.
If I add a filter (to any level, visual/page/report) on the posting date, very strange things start happening.
With basic filtering, I can select any number of dates that exist in the table, and the table visual will correctly sum the quantity for those dates and display it.
If I change the filter to advanced, and "is" some date that I know data exists (3 feb 2025) I get
but, if I add "is on or before" any date in the future (thereby not filtering anything) and include the same criteria as above as an "and" in the filter, it works.
I have been trying to figure it out for hours and am having no luck. I have already
- Created a new data model and replicated the issue
- uninstalled and reinstalled powerbi desktop
- adjusted the query to explicitly set the posting date field to date (it was already coming across as a date field)
- checked all locale settings
I am running PowerBI on a Parallels VM, but I have never had a problem with this for years.