Forum Discussion
Advocate IIIFilters on date slicer do not work as expected
Community SupportHi Quiny_Harl ,
This behavior is by design. There are 2 aspects collaborating together:
1. The relative date filter applies only 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.
I would recommend you use the same relative date filter to other visuals.
Referencing: https://community.powerbi.com/t5/Desktop/MAX-Date-wrong-Strange-MAX-DATE-behavior/td-p/2258170
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.
Quiny_Harlv-kkf-msft Please, reread my post again, especially the part where I explain how "if I choose different dates from the slicer, the visuals are filtered but at the moment I return to the original dates, the visuals are again not affected by the date slicer!". I don't think this is by design because when I move the slicer to return to the dates that represent last X years of data, the visuals show all the data and are not affected by the date slicer.
I am facing the same issue. When the relative filter is set to (eg. last 6 months), the report does not filter by date. Only when I go and pick a certain date, the filter is applied. Is there a way to workaround this? Only customerName is showing under filters not the date range as you can see below.
