I have a bar chart with month on x axis and Sum(sales) on y axis.I can sort the chart by fiscal month order or calendar month order.However, when I select the date range from say nov-2011 to jul-2012,my chart does not show Nov through Jul .It either shows Apr -May-Jun-Jul-Nov-Dec-Jan-Feb-Mar(Fiscal sort order) or jan-Feb-Mar-Apr-May-Jun-Jul-Nov-Dec(Caledar month sort order).I want it to show Nov-Dec-Jan-Feb-Mar-Apr-May-Jun-Jul. I have tried load order etc with no luck.Help please.
Re: Month sort order on chart with input date range
You seem to have a month-year field. Try sorting your month dimension in the chart by expression and choose your month-year field as expression. See attached example. If that doesn't work then your month-year field isn't a date. In that case create it as a date formatted as month-year: date(monthstart(MyDateField),'MMM-YYYY') as Month-Year