Reply
Allav
Frequent Visitor

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

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

image.png

1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

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.

View solution in original post

2 REPLIES 2
Nolock
Resident Rockstar
Resident Rockstar

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
Frequent Visitor

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. 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)