Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I'm trying to display some data in a text box, a "From" and "To" Date using values picked from a PowerApps report :
Ideally we want these in the format DD MMMM YYYY, the tables that feed these values are formatted accordingly :
However when trying to use these values from a Dynamic Value in a Text box the formatting is ShortDate by default with little/no option to change :
Is there any way to format the output of this Value to be the required DD MMMM YYYY format?
Solved! Go to Solution.
Hi @powertron ,
You have formatted the value again here.
Please recreate a value, keeping the default format here.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @powertron ,
Try formatting it in the Columns tool in Data View.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Gao,
This does not appear to have worked :
Still shows :
Hi @powertron ,
You have formatted the value again here.
Please recreate a value, keeping the default format here.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Gao,
Thanks, progress being made here. I now have it showing in the correct Format :
(Have only updated the second date here so far)
However, as you can see it has the second value as 1 January 2023, this despite the latest date in that Table being 8th March :
Not sure why "Max" isn't bringing back the later dates.
Hi Gao,
Figured it out :
Max Date of TaskPeriod.
Hadn't noticed you'd specified Date in the original advice. My Bad. Thanks for the help 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
95 | |
69 | |
44 | |
38 | |
30 |
User | Count |
---|---|
159 | |
98 | |
60 | |
42 | |
42 |