Sorting Columns on X-Axis E.g. Displaying Month Name

Please note that the recommended approach for a Data-mart KPI is:

The SQL statement should join to the DM_DIMTIMEPEROD dimension to get the month short name or month long name.
No java script is required when displaying short or long month names.

If you need to rename the labels to something that does not exist on the database then the instructions below show how axis labels can be overridden.

If an Optional Y Series Grouping is added to a Report then whatever is displayed on the X-Axis is automatically defaulted in as the Sort Order. This means that if the X-Axis is displaying Month Names then they will be sorted alphabetically, which is incorrect.

Please follow these steps to resolve the problem:

Put the month number on the x-axis.
Sort it in Ascending order.
On the Layout tab highlight the chart and click the Script tab
Select the beforeDrawAxisLabel function

See this URL for sample code:

http://www.birt-exchange.org/org/forum/index.php/topic/
            10988-changing-x-axis-labels-only/