Forum Discussion
Line Chart not Sorting in correct Order
Hi.
I dont know what your calendar table looks like, but if you use a separate date dimension or calendar table try this:
- Go to your calendar table in the data view.
- Selct the MonthName column
- Under the "Modeling"-tab in the ribbon, in the "Sort"-group, select "Sort By Column"
- Choose the column you want the column to sort by. With a proper date dimension or calendar table a YearMonth column is usually a good choice. But often MonthNumber will do.
To create a YearMonth-column if you dont have one you can add a custom calculated column in your date dimension table. A good format for such a column is "YYYYMM". This format will allways sort in the correct order. After adding this column you can choose it as a "Sort By Column" as per instructions above.
Hi.
I dont know what your calendar table looks like, but if you use a separate date dimension or calendar table try this:
- Go to your calendar table in the data view.
- Selct the MonthName column
- Under the "Modeling"-tab in the ribbon, in the "Sort"-group, select "Sort By Column"
- Choose the column you want the column to sort by. With a proper date dimension or calendar table a YearMonth column is usually a good choice. But often MonthNumber will do.
To create a YearMonth-column if you dont have one you can add a custom calculated column in your date dimension table. A good format for such a column is "YYYYMM". This format will allways sort in the correct order. After adding this column you can choose it as a "Sort By Column" as per instructions above.