Most dimension columns used in reports contain text values, and, by default, Power BI sorts these values alphabetically. To ensure these columns follow their logical order (for example, Jan, Feb, Mar) in report visualizations, it's necessary to store a corresponding column in the same dimension table and at the same granularity. For example, in addition to a Calendar Month column that contains the 12 text values for the names of the months, a Calendar Month Number column is included in the date dimension with the value of 1 for every row with the January value for Calendar Month, and so forth.
To set a custom sort order for a column, select the column in the fields list in Report View and then click the dropdown for the Sort ...
