How to sort year

[Anonymous]

I have a date column with YYYY/MM/DD

I have seen a slicer to the visualization look like this one below.

2010/2011

2011/2012

2012/2013

2013/2014

etc....

Anyone knows how I can  do it?

[ChandeepChhabra]

Try this calculated column formula

New Year =
YEAR ( Date[Date] )
    & "/" & YEAR ( Date[Date] ) - 1

Or 

New Year =
YEAR ( Date[Date] ) - 1
    &  "/" & YEAR ( Date[Date] )

You can then use this column to create a slicer, hope this helps

Thanks