Advanced filtering not working in Excel 2021

pls forgive is this is a dual post - I though I put this out a few days ago but I cannot find it.

I use Excel to handle large sets of data. In this case, temperature data by date.

The current xlsx has over 74,000 rows. I wish to filter these data and standard filtering functions do not seem to work.

Documents indicate that Advanced Filtering is the way to go.

I am unable to make this work. I recently spent over an hour with MS Chat Support (and with screen sharing) and between the two of us, we were unable to make this work.

Here are a few screenshots to show what I'm dealing with.

MS CSR diagnosed this and we were unable to make this work on another copy, or on other data, or on single digit data (rather than a date) and it seems to me like something is wrong here as I believe I am doing this correctly.

MS CSR also "repaired" the software and that also made no change.

Rebooting or reloading the software also did not make any differences..

This is a brand new copy of Microsoft Office Plus 2021 (for desktop).   

This is NOT 365 product.

Please - this is quite upsetting - please what is the procedure to further diagnose this issue - or more likely, train this user in doing this correctly??

DD