Sorting the X axis numericially isnt working

[mhapanka]

Hi in the graph below, i want the x axis to read - 2016-Q1, 2016-Q2 , 2016-Q3 and so on till 2018-Q3 so I sorted numerically with 'Fiscal year/ quarter' being the first to be sorted by however that is not happening and the years are all muddled up. How do I fix this?

[uroboros]

Hi Malika,

It because the data set that you need to sort have a text format; try sort with one expresion or with a date field!

Regards!

[nestigeek]

Try Sort by Expression and use your Date field

[sibin_jacob · Accepted solution]

Select the Sort by Expression option, then use the below expression.

NUM(Replace(Year_Quarter,'-Q',''))

Then Select Ascending.

[balabhaskarqlik]

May be try like this:

Date(Aggr(Max([Close Date]),FinancialYear/Quarter),'YYYY-MM')