Forum Discussion

e175429's avatar
e175429
Helper IV
1 year ago
Solved

Changing Date Format

Hello all,   This is my x-axis, with some of the months cut off because it's too long.   Is there any way to change the format to a month/year format like "Jan 23"?   Or are we bound to t...
  • Syk's avatar
    Syk
    1 year ago

    You can format the date a ton of different ways by creating a new column. This should give you what you want.

    Date Format =
FORMAT ( 'Date'[Date], "mmm" ) & " " & FORMAT ( 'Date'[Date], "yy" )
e175429's avatar
e175429
Helper IV
1 year ago

Sorry, I should've been more specific.

 

When I try to order the new column by Date I get this message:

I'm only given 2 options to sort the axis itself. This is one:

And this is the other:

 

 

 

Syk's avatar
Syk
Resident Rockstar
1 year ago

Try ordering it by your month-year sort column.

  • e175429's avatar
    e175429
    Helper IV
    1 year ago

    I did not get a error but it's still out of wack.

     

    • Syk's avatar
      Syk
      Resident Rockstar
      1 year ago

      Your year month sort column is sorted alphabetically. You need a Year Month Code to properly sort. 

      Year Month Code = FORMAT('Date'[Date],"YYYYMM")

      Then sort your columns by this and you should be good to go.

      • e175429's avatar
        e175429
        Helper IV
        1 year ago

        You are going straight to heaven!

         

        Thank you kindly