How to sort year

Anonymous · ‎05-28-2019

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 · ‎05-28-2019

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

Helpful resources