Forum Discussion

rdreyer's avatar
rdreyer
New Member
4 years ago

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

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 Powe...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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-report-Builder/m-p/1578371

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

https://community.powerbi.com/t5/Report-Server/Power-BI-Report-server-not-showing-dates-in-consistent-format/m-p/1855126

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's avatar
rdreyer
New Member
4 years ago

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's avatar
    rdreyer
    New Member
    4 years ago

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