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.
-
bhalicki
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on:
Fix the Date function in DAX
-
Stinkys
on:
Cannot login to community site
-
reubwork
on:
May 25 update for Snowflake Connector v2 has broke...
-
dmkblesser
on:
Unable to open existing PBIP files
- DamoUK on: Gateway issues
- davidebacci on: Total Labels not following dynamic formatting rule...
-
mattlee
on:
Hover on button is not working with latest update.
- dummy_user_name on: dynamic m query parameters not working for snowfla...