Sort by month (9,10,11..) & year (2018, 2019..)

[Allav]

Hello,

I have a dashboard with tables and charts in my visualization which are connected to a table which has seperate columns for months and years. the months are indicated as numbers.

I had the months of 9, 10, 11, 12 of 2018 and now am adding also 1 of 2019 which is now causing me issues with sorting as this january comes first.

in my table and charts I add the month into the visualization and sort by it. then I tried to add the year field into the tooltip and sort by it (as a secondary sort)... this doesn't work

I hope someone here could have a better idea for me

[Nolock · Accepted solution]

Hi @Allav,

I don't think so it is possible to break an order of an axis. An axis is always ascending or descending, but you expect, that there are for example 10, 11, 12, 1, 2, 3, ...

What you can do, is to create a new column with a format like yyyy-MM (e.g. 2019-02) and use it as your axis. Then the values will always go up.

[Allav]

Thanks, after trying few different options I think that your sugestion is the only way to go about it. I could not find a way to do sorting by 2 fields.