Pivot Table Showing Dates Outside Date Range

[billdf99]

Hello all. I've come here periodically to find answers to Excel problems, but can't seem to find an answer to an issue I'm having now. So I set up an account to ask myself.

I've tried searching and playing around with this, but can't seem to find a solution. When I create a pivot table from a list of dates, the pivot table filter includes an option for less than my lowest date and more than my highest date. Obviously there is no data in those 2 filters. The problem with that is that they are showing up in some slicers that I set up and are messing up some graphs that are based on those slicers.

Is there any way to remove those options?

Thanks for the help.

 

[billdf99]

Here's an image that might help show what I mean.

 

[billdf99]

Actually, a link of the image is easier:

https://www.dropbox.com/s/ssaxmw7p984g6j5/excel date filters.jpg?dl=0

 

[RoryA]

You can't remove them, but you can hide them on your charts using filters.

 

[billdf99]

You can't remove them, but you can hide them on your charts using filters.

Thanks for the response! I have tried filtering them out, but then, they still show up in slicers, so when someone clears the selection, the filter is removed.

Is there any way to resolve this?

 

[RoryA]

Add a year column to the source data instead of grouping in the pivot table. Then you won't have that issue.

 

[billdf99]

Good idea! I'll try that. Thanks.