Date slicer is not working properly for single date selection using Direct query in power bi

[Anonymous]

I have a date column in my table where am using this column as date slicer. Then i created a date parameter for direct query usage

and bind that parameter to this date slicer column ,

My problem is am unable to select before option in settings. Only i can see is list,dropdown etc.There is no option of between,before and after in slicer setting.

Why its is happening like this?

[Ritaf1983]

Hi @Anonymous 
If there are no options for dates / numeric functions  (ranges functionality )it is a data type issue for some reason your date field is recognized as text.

Check if the linked discussion can help:

https://community.fabric.microsoft.com/t5/Power-Query/Date-not-showing-in-direct-query/td-p/1437937