Cannot remove <than for dates prior to first date in database.

[Livin404]

For the life of me I can get <6/1/2021 out of my pivot table/slicers. I think I tried everything from hiding items with no data in slicer settings. I know it has to do with the table more than the slicers. I used the date filter to only show items that begin on or after 6/1/2021. This leaves (blank) in other filters. I created data labels not to show "blank". However, those filters don't last long at all. It is driving me mad. Does any one have any suggestions?

Thank you,

 

[Alex Blakenburg]

Apparently the only way to get rid of them is to create a helper column in your database and use this for the slicer.
You don't need to use the column in the actual pivot.

See this artice by Mynda Treacy on Myonline training.
Go to the heading that says "Slicers for Years and Months"
Quote
"there are two things that aren’t ideal"
Item 2 refers to the < & > than Buttons "and there is no way to remove them."
There is then a Solution heading which talks about using a helper column.
https://www.myonlinetraininghub.com/create-a-single-excel-slicer-for-year-and-month