Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
okletsgo
Advocate II
Advocate II

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?

1 REPLY 1
ChandeepChhabra
Impactful Individual
Impactful Individual

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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.