Relative date slicer strange outcome

[DMSJennifer]

Hello, 

Since a brief perod of time, I've had the following issue:

When using the scroll bar in the date filter, it shows its is selected on 2021: 

Unfortunately, for some reason, the visuals on the page don't show 2021 data. When checking the value, the following is shown: 

This explains why the data isn't shown over 2021, but I wonder why this happens? 

When typing directly 2021 into the field, the data is shown correctly. This problem only accurs when usin the scroll bar. (And that is an appliance we use a lot in our company)

Can anyone help me with this?

Kind Regards,

JenniferDMS

[v-zhangti]

Hi, @DMSJennifer 

Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance.

Best Regards

[amitchandak · Accepted solution]

@DMSJennifer , can you make sure the data type of this column is the whole number. I think this because a number is a decimal number