Forum Discussion

revansh's avatar
revansh
Helper IV
9 years ago
Solved

Date Format

Hi Everyone,                  I have a line graph with month start date on X-axis.    Month start date format = MM-YYYY (i.e. JAN2017 , FEB2017, MAR2017).   I want to change the format to MM-YY...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    revansh

     

    Create 2 columns (1 to display and to sort it)

     

    Custom Column = FORMAT('Calendar'[Date], "MMM YY")

Custom Column Sort Order = 
INT (
    CONCATENATE ( YEAR ( 'Calendar'[Date] ), FORMAT ( 'Calendar'[Date], "MM" ) )
)

    Then Select the Custom Column => Modeling Tab => Sort Column By => select the Custom Column Sort Order column

     

     

    That should do it.

    Good Luck! :smileyhappy:

Sean's avatar
Sean
Community Champion
9 years ago

revansh

 

Create 2 columns (1 to display and to sort it)

 

Custom Column = FORMAT('Calendar'[Date], "MMM YY")

Custom Column Sort Order = 
INT (
    CONCATENATE ( YEAR ( 'Calendar'[Date] ), FORMAT ( 'Calendar'[Date], "MM" ) )
)

Then Select the Custom Column => Modeling Tab => Sort Column By => select the Custom Column Sort Order column

 

 

That should do it.

Good Luck! :smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you Sean. That worked for me also. Any idea how we can do it for a YTD chart?

 

I am using a measure that use monthly sales cost and date to get YTD for each month. Something like this.

 

YTD = TOTALYTD(SUM(Sales[Cost]),Sales[Date]) 

 

But when I use, Date(MMM YYYY) = FORMAT(Sales[Date],"MMM YYYY") in the charts, it messes up my YTD chart.

 

Any ideas how to can we make it work?

 

Thanks!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    select the column and go to column tools.

    Select the data type and set it as "Date"

    select format and type as mmm-yy