Auto grouping of dates in filter after updating data

[RRich39]

When I update the data source, the Date filter stops displaying the data in the rows and automatically groups it by month rendering it unusable for my model.

From this

from this.PNG

To this
To this.PNG

[XLent]

You could try disabling "Auto Grouping of Date/Time values in Pivots" -- you can find this setting in Options -> Data -> Data Options