Forum Discussion
Austen229022
Helper II
Helper IISlicer not taking full dates
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 da...
HotChilli
Community Champion
Community ChampionCould 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
Austen229022Helper II
Helper IIYou 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