Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
I need an urgent solution for Report Builder. I have created the parameters subscriber number, start date, and end date. For a moment I have the date in text format in default.I want to change the format of the date from the text to the date format so that I can apply the calendar option for my customer. Can anyone tell me how to change the date format in the report builder?
I have tried to change the format of date by selecting data type in parameter properties but it didn't work. I think I have to change something in Query. Can someone tell me what I am missing here?
Thanks in advance 🙂
Solved! Go to Solution.
Hi @Anonymous ,
Would you please try to change the orderdate to date type when you query the table in report builder. Please try something like:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
Would you please try to change the orderdate to date type when you query the table in report builder. Please try something like:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you Dedmon. It worked.
Hi @Anonymous ,
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Currently, I am using Report Builder to set the Parameter option for my customer. The data source which I am using is Oracle.
This is the step by step process I am doing:
Hi, @Anonymous
Try this function : cdate()
Thanks for the reply Davis. Could you tell me where I can use this Cdate() function and what is the syntax for that ?
I am quite new to this report builder thing.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |