I have a table set up like a check register. I have a date column names Date with full date ie 12/15/2023. I have a slicer set up for date, but want to limit it to only the month, not each individual date in the register. So, I set up another column with Month. The formula in that column is =[@Date]. I then format the column to only show MMM. I then set up a slicer with that column. So, the slicer shows the months ie Jan, Feb, Mar etc..
The issue is when I click on say, Jan (slicer) it only shows 1/1/2024, same for Feb and Mar etc... I thought maybe the format was off, ie showing dd/mm/yyyy, but I'm in the US and the clock/date is set to US region. So, I put in some dates like 12/1/2024, 12/18/2024 and when I click on the slicer for Dec it only shows the 12/1/2024 items.
Dennis
The issue is when I click on say, Jan (slicer) it only shows 1/1/2024, same for Feb and Mar etc... I thought maybe the format was off, ie showing dd/mm/yyyy, but I'm in the US and the clock/date is set to US region. So, I put in some dates like 12/1/2024, 12/18/2024 and when I click on the slicer for Dec it only shows the 12/1/2024 items.
Dennis