Date Slicer is not filtering based on end date

[wc123]

Hello,

We have a date slicer in one of our reports that was malfuntioning. It should have been filtering based on two dates so between lets say 4/1/2025 and 4/30/2025 but the table that gets affected by the filter was only saying it was on or after 4/1/2025 instead of on or after 4/1/2025 and before 5/1/2025.

[v-sdhruv]

Hi @wc123 ,
Can you please  mark your answer as  Accept as Solution so that other users can benefit from it?

[v-sdhruv]

Hi @wc123 ,
Good to know your issue got resolved.
Can you mark your answer as a Solution so that other users can benefit from it?

[v-sdhruv]

Hi @wc123 ,
Good to know your issue got resolved.
Can you mark your answer as a Solution so that other users can benefit from it?
Thanks for reaching out on Community Forum!

[v-sdhruv]

Hi @wc123 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[wc123 · Accepted solution]

There was no user error here it must have been a bug, it has resolved itself.

[v-sdhruv]

Hi @wc123 ,
Thanks for clarifying!
Make sure the slicer is set to “Between” and not “Relative” or “After” for everyone as pointed out by @Akash_Varuna .
Sometimes Power BI can switch slicer modes unintentionally or during updates.
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[wc123]

To make it more clear this was not an issue for most users but some users experienced this glitch. It has nothing to do with data type or anything like that as it was working properly for months before this.

[v-sdhruv]

Hi @wc123 ,
It could be because the data type of the column in DateTime and not date.
Change it to Date format.

If your table column is of datetime type, and you're using a date slicer, the slicer only sets the filter as:

• >= 2025-04-01 00:00:00

• <= 2025-04-30 00:00:00

So any values on 4/30/2025 after midnight are excluded.
or
Add a calculated column to strip off timestamp-
DateOnly = DATE(YEAR('Table'[Timestamp]), MONTH('Table'[Timestamp]), DAY('Table'[Timestamp]))
and use this as a slicer.

Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[Akash_Varuna]

Hi @wc123 It is likely due to the slicer being set to "After" instead of "Between," causing it to filter only from the start date onward. Additionally, the issue could stem from inactive or incorrect relationships between the date table and the affected table. Please check the relationship and the data type of the field being used is date time.