Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NISHA_S
Resolver I
Resolver I

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

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?1.PNGCapture.PNG

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @NISHA_S 
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

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.