Question

You build a column chart showing total sales by month. The X-axis uses a text column called 'Month Name' (January, February, etc.). The months display alphabetically (April, August, December...) instead of in calendar order. Your model already contains a numeric 'Month Number' column (1–12) in the same table. What is the most appropriate way to fix the ordering?

Accepted Answer

Select the 'Month Name' column and set its Sort by column property to 'Month Number'.

Answer

In the visual, set the X-axis to sort by 'Month Name' in ascending order.

Answer

Create a calculation group that reorders the month labels at query time.

Answer

Change the data type of 'Month Name' to Whole Number so it sorts numerically.