Powerbi Desktop Report Builder - How to remove time from date parameter

[rdreyer]

Hello,

Just trying to display date only and not date/time in my report parameter that is pulling date from my dataset. I have already transformed my dataset on the backend to show date only but PowerBi Report Builder parameter continues to show both date and time. Any thoughts and thanks in advance!

[v-yangliu-msft]

Hi  @rdreyer ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Report-Server/How-to-set-calender-option-in-date-parameters-in-repo...

https://community.powerbi.com/t5/Desktop/POwe-Bi-Report-Builder-Date-time-Conversion-failed/td-p/148...

https://community.powerbi.com/t5/Report-Server/Power-BI-Report-server-not-showing-dates-in-consisten...

https://blog.coeo.com/using-date-pickers-in-power-bi-report-builder

Best Regards,

Liu Yang

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

[rdreyer]

Hi v-yangliu-msft,

Unfortunately, none of these seem relative to what I am trying to do. See below and think the solution is to update date format within the dataset query. I cannot find the syntax for converting date to short date. Any thoughts?

I think I need to convert the date within the Evaluate Summarizecolumns query....

EVALUATE SUMMARIZECOLUMNS('Dataset'[TestDate])

Thanks!

[rdreyer]

Forgot to add that my datasource is Sharepoint Online so not able to use standard SQL and date function in the query