Power BI Report Builder - Date datatype from Power BI Dataset coming through as text

[TheCAKurtle]

Hi there, 

I am new to Power BI report builder. I am trying to make a report with a simple date range parameter... However, my date column (which is also marked as the date table) is coming through as text so selecting dates is a long drop-down list instead of a calendar. Does anyone know how to correct this? 

Thank you in advance. 

[markabdey]

Did you ever find a solution to this? I'm having exactly the same issue. The column is a DATE in the underlying dataset but coming through as a text in the rdl file.

[v-jayw-msft]

Hi @TheCAKurtle ,

You need to convert your date column to date format.

Show some sample data and we might be able to help you convert it with formula or format feature.

Or you can check the documents below about how to convert format in power bi.

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

https://community.powerbi.com/t5/Desktop/how-to-change-text-to-date/td-p/16067

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@TheCAKurtle , What format data is coming. Have you tried changing data type to date.