Slicer not taking full dates

[Austen229022]

I have a slicer that is dated MMM yy eg: Feb 23, which has all the dates from the past 12 months

What I am needing it to do is filter everything that is within that month as records are by the date received (eg: 14/02/2023). Currently it is only bringing up the values from the first of the month as the date data shows it as 01/02/2023.

How can I get it so that when I select a month in the slicer that it will show all the data for that selected month?

This works when I use a relative date slicer though this doesnt fit what I am needing to do

[HotChilli]

Could do with more detail to solve this.

It may be that the slicer holds dates like 1st Feb 2023 but they are formatted as MMM YY (but it still represents the 1st so it only matches with data from the 1st)

One way to solve this would be add a calculated column for Month / Year (in text form) and put that in the slicer.  Usually best practice would be to use a Date table with a 1:m relationship to the Fact table

[Austen229022]

You are correct that it holds the dates like 01 Feb 2023 which is formatted as a calculated column as "MMM yy" so it still thinks its the first of the month.

I use this column to try and filter the data though it only pulls the 1st of the month