Forum Discussion

JennaExe's avatar
JennaExe
Helper I
2 years ago
Solved

Custom date format

Hi, I want to shorten the dates on my graphs from e.g. "September 2023" to "Sep-23". I found a way to do this online, by creating a new column in the modelling tab and using the formula Short_Date = ...
Need Help
  • manvishah17's avatar
    manvishah17
    2 years ago

    Hi JennaExe , 
    You have created MonthYear column. 
    Now create a new column by this formula 

     

    Sortkey = FORMAT('Date'[Date], "yymm")

     

    Then sort your month year column by this SortKey column.
    Sorting

     

    Output

     

     

     

     

     

     

     

    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!

     

manvishah17's avatar
manvishah17
Solution Supplier
2 years ago

Hi JennaExe , 
You have created MonthYear column. 
Now create a new column by this formula 

 

Sortkey = FORMAT('Date'[Date], "yymm")

 

Then sort your month year column by this SortKey column.
Sorting

 

Output

 

 

 

 

 

 

 

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!

 

JennaExe's avatar
JennaExe
Helper I
2 years ago

This has solved it, thanks so much for your help! And thanks to the others for trying to help too!