Pivot Table Slicer Shows Dates which are not actually in the data <1/1/2024 or >=1/1/2017

[Sufiyan97]

I have a data in which I don't have dates <1/1/2014 or >=1/1/2017 but slicers still shows them, how to get rid of them

 

[DanteAmor]

Try:

Right click anywhere on the slicer and select "Slicer Settings" from the drop down.
On the bottom right select the box that says "Hide Items with no Data".

 

[Sufiyan97]

It is already unchecked

 

[DanteAmor]

Also turns off "Show items..."

Try and tell me

 

[Sufiyan97]

Done

but still

 

[DanteAmor]

Before Hide items:

After Hide items:

 

[MARK858]

Done

???? it isn't done in the image that you posted in post 5, the Hide Items box on the right hand side should have the box checked.

Your image is below and the box is not checked

 

[Sufiyan97]

Thanks @MARK858 , even @DanteAmor 's 2nd post mentioned the same thing but I read it as "uncheck".

Thanks both of you for your help!


Currently It is now allowing to mark post as solution, when I click, it shows confirm and when I click it, nothing happens.

 

[DanteAmor]

On the bottom right select the box that says "Hide Items with no Data".

But in post #2, I commented that you should select "Hide Items with no Data"

And then I asked you to uncheck but "Show items deleted from the data source"

I think you should pay attention to what I write.

Finally, if you already checked "Hide Items with no Data" and it already works for you, that makes me very happy.