Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Fiscal Year Dynamic Filter Not in Order

I have a filter in my header for the current Fiscal Year the tab is filtered to, but it is not in order.

 

It goes: 2019, 2020, 2021, 2022, 2018, 2017.

Fiscal Year Header = 
var FYs = CONCATENATEX(DISTINCT('Data'[Fiscal Year]),[Fiscal Year], ", ", [Fiscal Year],ASC)
return
"Fiscal Years: " & FYs
 
How do I make it ordered?
Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Your formula works for me.  Is yours maybe a calculated column?

     

    Fiscal Year Header := "Fiscal Years: " & CONCATENATEX(VALUES(Data[Fiscal Year]),[Fiscal Year],", ",[Fiscal Year],ASC)