Wrong max date in date slicer with relative filtering

[Anonymous]

Hi all,

I am currently struggling with a report, which contains data in the future (until year 2028). To filter the actual data, I added a slicer with a filter on the visual for the last 30 days. If I now move the max date in the slicer to the maximum available date (05.02.2020), the slicer takes the maximum value (31.12.2028) of the data. This is not the correct behavior, right? If I select tomorrow (06.02.2020) manually from the calendar, then set it back to today (05.02.2020) the slicer filters the data correctly. How could that be and how am I able to achieve the correct behavior?

Thank you for your help.

[Anonymous]

Does someone have the same issue? @v-lid-msft Could you reproduce the behavior?

Regards

[v-lid-msft]

Hi @Anonymous ,

Sorry for our late reply. We cannot access the video you shared with, but based on your description, if put the visual filter in the slicer, it will only limit the available selection of slicer visual, you need to select the value in it, then it will filter other visual, we can change the slicer to list, you can see the 2020-02-05 does not select. We can put the date filter in the page level filter to affect all the visual.

Best regards,

[Anonymous]

Hi @v-lid-msft ,

I see the problem. But that means, that I am not able to create a slicer, which initially filters the data to the last 30 days in the report. The problem is, that with range slicers users get the visual impression, that the currently selected range is filtered on the page. But the filtering only happens, when the slicer is moved. But even if it's moved, the behavior is not correct. If the date slicer is set through the calendar and then reset with the mouse, the maximum value is not filtered. Please check the video below, I uploaded it on YouTube:

https://www.youtube.com/watch?v=td60pr3WElk 

Thank you for your help.

Regards

ephrem 

[mwegener]

Hi @Anonymous,

it works as designed.

The visual filter only filters the selectable values of the slicer.

If no further filter value is selected on the slicer (ALL), no filter is propagated.

If the filter is to apply to all visuals on the page, it must be used as a page filter.

[v-lid-msft]

Hi @Anonymous ,

Sorry for that, we cannot reproduce this behaviour according your description, could you please reproduce this issue on a sample file or describe the reproduce steps with more detail?

Best regards,

[Anonymous]

Hello @v-lid-msft 

I am able to reproduce the error in you file attached. 

• If I open the file, the date table shows future dates even tough you have set relative date filtering on the slicer, which limits the slicer to 2020-02-05.
• After that, I change the from-value e.g. to 2020-02-04. Now, the date 2018-02-05 disappears, but the to date is still not filtered (values up to 2028-12-31 are shown).
• The to-filter dows not come to effect until I set the to date to e.g. 2020-02-06 (with calendar).
• If I change the filter to 2018-02-04 and then to 2019-02-05 (with the slicer), the to-date is again not filtered. 

I attached a video how I reproduced this error, sorry if my first post was a bit unclear.

Video link 

Regards

@Anonymous 

[mwegener]

Hi @Anonymous ,

could you share some screenshots?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.