Forum Discussion

SoulCuber's avatar
SoulCuber
Frequent Visitor
10 years ago
Solved

create own date format dd d-MMM-yy

I would like to display dates in charts including the weekday.   There is one standard option available which is: Wednesday 1 March 2001 (dddd d MMMM yyyy)   However for display purposes, I would...
  • Anonymous's avatar
    Anonymous
    10 years ago

    You can create a calculated column, and use the FORMAT( ) function to specify any format string you desire :)

  • hohlick's avatar
    hohlick
    10 years ago

    If in Power Query (Query Editor), you can use Date.ToText() function for the same goals.

    Just dont forget to set "sort by column" option later when modelling data

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

You can create a calculated column, and use the FORMAT( ) function to specify any format string you desire :)

SoulCuber's avatar
SoulCuber
Frequent Visitor
10 years ago

Clever idea, many thanks Maxime and Scotsen!

  • GenoRockMdt's avatar
    GenoRockMdt
    Frequent Visitor
    7 years ago

    We should not need to be so clever honestly... What is wrong with just letting people define whatever date format they want to show - just like Excel does? 

     

    The Format option in Modeling shows the underlying elements... MMMM, MMM, MM, M, dd, ddd, hh, mm, etc...

     

    What is so hard about making this easy?  The list in Power BI is actually missing the most critical formats in my opinion for designing good, compact visuals...  yyyy-mm-dd and dd-mmm-yyyy

     

    Format and such convert to Text which doesn't sort correctly.  Doing some sort of back-side sort is not what one would call friendly.