Dynamic format %, Number, and Date

[RH205]

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?

[RH205]

thanks, but this is not helping me. I read the documentation and used multiple formats, but it does not change..

[v-aatheeque]

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 !!

[v-aatheeque · Accepted 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.

[v-aatheeque]

Hi @RH205

Just a quick reminder the provided  recommended DAX syntax to format dates as dd-mm-yyyy using the FORMAT () function:

 
FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")

If it's still not displaying as expected, please let us know where you're applying it (e.g., card, matrix, etc.)

so we can assist you further.

[FBergamaschi]

Can you share the pbix via some cloud service?

[FBergamaschi]

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