Sorting Clustered Column Chart by FY Year and Month Name

[prabhatnath]

Hi Friends,

I have a FYCalendar Table with below columns where FY Starts in JULY:

And a Tickets Table with columns like:

TicketId, CreatedDate,  Title, Status, Owner. 

I have a Column Chart where X Asix = FiscalYearText and FiscalMonth columns from FYCalendar table and Count of TicketId from Tickets Table. Both the tables are Joined on CreatedDate = Date. I need help on sorting the Columns based on FY and then MonthName. Please suggest how can I get that done. 

Thanks,

Prabhat

[Idrissshatila · Accepted solution]

Hello @prabhatnath ,

click on the month column and then click on the sort column by option and pick the fiscal month num column.