How do I remove the dates I don't want and only keep those I want in the slicer?

[joshtech]

Hi Community,

I'm trying to create a slicer for page of up to a year.

However, because the data set I have goes way back to 2010, may I know how do I clean away the rest of the old dates and only keep the 2024 till todate?

I want to remove the old dates as seen in the yellow highlights.

Thank you.

[AlanP514]

Hi @joshtech ,
We can achive this in several ways 
1st way we can achive through applyinf filter conditions like is on or after 01/01/2024

2nd  method 
Create a new column
slicershow = if(Your table[date] >= date(2024,1,1),1,0)

then apply this in visual level filter  using slicershow = 1



3rd method 

create calculated table 

slicer date = calendar(dates(2024,1,1),Today())

Hi @joshtech  if this post helpful means please accept it as solution

thanks 

[Idrissshatila · Accepted solution]

Hello @joshtech ,

filter the date field that you're using from the filter pane as the following