Is there a way to create custom date formats?

[Anonymous]

I'm looking for a way to create a custom date format as DD/MMM/YYYY

but right now Power BI only supports DD/MMM/YY.

[Stives93]

You can now apply custom date formats within Model View, without having to convert to text in query editor or via a measure.

[mahoneypat]

If you need to use this in the query editor (e.g., you have additional data transformation to do with it), you can use Date.ToText().  For example, a custom column with this formula

= Date.ToText([DateColumn], "dd/MMM/yyyy")

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anand24 · Accepted solution]

Hi @Anonymous ,

You can achieve the DD/MMM/YYYY format by creating a new column with below DAX:

Date_Column = FORMAT(Tablename[date_field],"dd/mmm/yyyy")

Refer below image:

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[JimT99]

This works but it converts the date to text.
I want to keep the field as date wth the format "mmm/yy"
Once it is formatted as mmm/yy as a new column I  am forced to convert to date and then am stuck with the default formats in Power BI

[Greg_Deckler]

@Anonymous - There are custom date formats in the FORMAT function, 

https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function

Also, you can do custom formatting using Custom Format Strings:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

This is how Chelsie Eiden's Duration works: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[amitchandak]

@Anonymous , refer one in model view can help

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings