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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.