Advanced filtering option is not available for filters if the Requires Single Selection checkbox for the particular filter is checked
Is there any specific reason you want to use Advanced Filter when Require Single Selection is enabled?
In my perspective, as you already enabled Require Single Selection, we can only select one value each time. It doesn't need to use Advanced Filter.
Best Regards,Qiuyun Yu
@v-qiuyu-msft: Thanks for your reply
To be more clear on the requirement, the filter is a Date field and if we use a drop down for the selection, the user will be facing difficulty in selecting the date as they will have to scroll till the end to identify the date which they are looking for. Thus we are trying to use Advanced Filtering so that a Calendar date picker will be available for the user to select dates bit more easily.