Sort Order in Graph

[shamitshah]

Hi,

I have a calculated dimension as =If([Fiscal Year] < Year(Today()) or [Fiscal Year] > Year(Today()), [Fiscal Year],[Fiscal Period]) .

I am not able to get the correct sort order in a bar chart (see below). I am trying to show ascending Fiscal Years for prior years and the by Fiscal Period the current year (2017).

Any idea on how I can achieve the correct sort order - ascending by Fiscal Year and Fiscal Period?

Thanks

[Anil_Babu_Samineni]

You are calculating the [Fiscal Year] and seems you used Period if filter not happens. Can we know the reason or intend to show. Could be the reason Period field. Or can you enable all options from Sort tab and promote the calc. dim if it not in first place from Sort tab

[vinieme12]

Check this out

Period Presets: Compare Periods on the fly

[shamitshah · Accepted solution]

Hi,

I used the following and it seems to be working fine:

Sort by Expression using Fiscal Year, followed by Numeric Value

Thanks all.