Sorting Dates & Date Labels

[dgodley12]

Hello All, 

I am using a graph to show vendor spend, and it does not let me add the year next to the months. For example it only displays January and I want to it show January 2018. It also should be sorted in date order. All of the months are 2017, except Jan-Feb-March which are 2018. does anyone know how to fix this? 

[MFelix · Accepted solution]

Hi @dgodley12,

Add the following column to your data model:

Date Year = Format (Table[Date]; "YY - mmm")

You can format it in different ways and then use it on your chart.

Regards,

MFelix 

[danextian · Accepted solution]

Hi @dgodley12.

You can try this DAX formula as a calcualted column.

Month and Year =
FORMAT ( 'Table'[Date], "mmmm yyyy" )

And then create another calculated to sort Month and Year by.

Month and Year Sort =
 FORMAT ( 'Table'[Date], "yyyymm" )

[MFelix · Accepted solution]

Hi @dgodley12,

Add the following column to your data model:

Date Year = Format (Table[Date]; "YY - mmm")

You can format it in different ways and then use it on your chart.

Regards,

MFelix