MAX Date wrong / Strange MAX DATE behavior

Hi Anonymous ,

Microsoft has given its internal response. This behavior is by design. There are 2 aspects collaborating together:

1. The filter on Year = 2019, 2020, 2021 applies solely to the values that are selectable in the slicer. That filter won't propagate anywhere else.

2. A behavior of the range slicer is that if the customer does not move the slider at both ends, as shown in the figure below, there is effectively no filter applied.

So if you never changed the ends of the range, either by dragging the slider or typing in a value, or if you selected the values that are the Min or Max, the filter won't do anything in actuality. This is to allow scenarios where one of the ends keeps changing (e.g. more days of data have been brought in so the filter remains dynamic to that and applies the latest date instead of a static date).

I would recommend you use the Y column to create another slicer.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.