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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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