Forum Discussion
Dynamic format %, Number, and Date
Hi all!
Question..what syntax does it need to show the correct "dd-mm-yyy" in the dynamic format option? decimal and percentage are fine, but the date is not..is there a solution?
Hi RH205
Just a quick reminder that the engineer has already shared the recommended syntax for displaying dates in the dd-mm-yyyy format using the FORMAT() function in DAX.Example:
FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")If the dynamic format option still isn't reflecting this as expected,
feel free to share where you're applying it (e.g., card, matrix,) so we can assist further.
6 Replies
Here yo ufind the options for sate and time formats
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
thanks, but this is not helping me. I read the documentation and used multiple formats, but it does not change..
Can you share the pbix via some cloud service?
Hi RH205
If you're using a measure or calculated column and want to display the date in dd-mm-yyyy format, use:FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")output Result = 12/15/2020 will be date column.
Hope it helps !!Hi RH205
Just a quick reminder that the engineer has already shared the recommended syntax for displaying dates in the dd-mm-yyyy format using the FORMAT() function in DAX.Example:
FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")If the dynamic format option still isn't reflecting this as expected,
feel free to share where you're applying it (e.g., card, matrix,) so we can assist further.
