Date field in Direct Query

Heinrich Hi!  it could be because the field is formatted as text instead of date or datetime. Power BI slicers require date fields to be properly recognized as date types to function correctly.

1. You can add a calculated column in Power BI that parses the text date into a date type:

Go to the Modeling tab, and choose New Column.

Use a formula to convert the text into a date. Here’s a formula:
ConvertedDate = DATEVALUE('TableName'[DateField])

2. In Power BI Desktop, go to Transform Data to open Power Query.
Find the Date field in the query editor, select it, and then change its data type to Date or DateTime (depending on your needs).
This transformation may work depending on the configuration, but if it’s not allowed in DirectQuery mode, then stick with 1 above.

BBF