Slicers showing ">9/7/20201" and ">9/14/2021"

[NewYears1978]

I am working on my first large dashboard with a huge set of data, several pivot tables and charts etc. It's going really well. I finished a monthly sales report and wanted to add a Weekly slicer to be able to affect all the graphs on the dashboard.
I added a new pivot table with just dates and grouped them by 7 days to get my weeks. Then I added the slicer. It works perfect, however there are two choices that are showing less than a date and greater than a date..but I am not sure what that means???

I know I can disable these with "Hide slicers with no data" - but just curious why they appear (for learning purposes).

Lastly, I have the slicers in Ascending order and in the Table it is correct, but in the slicers excel is putting them out of order for some reason. (See image attachment)

[JeteMc]

It may be easier to help if we had the Excel file to work with.
That said I believe the order is because those are text values which Excel is sorting in ascending order.
As the sort algorithm reads the text from left to right the second slicer choice is 9/1... and the third is 9/5...

[NewYears1978]

It may be easier to help if we had the Excel file to work with.
That said I believe the order is because those are text values which Excel is sorting in ascending order.
As the sort algorithm reads the text from left to right the second slicer choice is 9/1... and the third is 9/5...

Yeah the data set is too sensitive and if I make a sample it doesn't always reproduce the same error. I will mark this solved for now. I had to switch to Data Model version which behaves completely different - and introduces a whole new problem.

[JeteMc]

Thank You for marking the thread as 'Solved'. I hope that you have a blessed day.