Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to sort year

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?...
Need Help
Show and Tell
Tips and Tricks
ChandeepChhabra's avatar
ChandeepChhabra
Impactful Individual
7 years ago

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