Date field in Direct Query

[Heinrich]

Hello
I am using CQD for making some reports

The CQD is DirectQuery. Which type is the Date-Field.
I would like to do a slicer and this does not work.
Is it possible to find out which type it is
And how if "text" it can be reformatted locally.
Have a great day
JFM_12

[BeaBF]

@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

[Heinrich]

Hello BeaBF Thank you very much for your answer. Have a great day JFM_12

[BeaBF · Accepted solution]

@Heinrich if my answer has resolved your problem, please accept it as solution. 

How has it worked?

BBF