Forum Discussion
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...
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:
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:
It worked.
Thank you.