sort months into chronological order

[Anonymous]

This is the error message I keep getting as its the rolling column which I have in my visual which needs sorting I think, as every other column which has been sorted has not affected the order. 

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

You can create a sorted table, then establish a one-to-many relationship between the sorted table and the main table, use the RELATED function to create a sorting column in the main table, and finally make the rolling column sort by the sort column.

sample:

result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft]

Hi, @Anonymous 

According to the above error message, the same value in the Rolling column has multiple sorts in the sorting column, so it cannot be sorted normally. Multiple values in the Rolling column can be allowed to have the same order in the sorting column, but the same value in the Rolling column is not allowed to have a different order in the sorting column, which will make PowerBI confused. So check the value of the rolling column, update the relationship between the rolling column and the sorting column (1:1 or *:1), and try again.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hiya thanks for the reply.

How do I make them *:1 in the same table?

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

You can create a sorted table, then establish a one-to-many relationship between the sorted table and the main table, use the RELATED function to create a sorting column in the main table, and finally make the rolling column sort by the sort column.

sample:

result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Small issue im now having.

I have 6 months values being shown and rest of the year/s totaled at the end, however, 'rest of the year' is showing up before the final month in my 6 months which is January. 
heres some pics for reference:

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

I noticed that the value in your sort table is "Rest of the Year", but the mapped value in your main table is "Rest of the Dates", and the value is different causing this to not correctly identify the sort order.

Best Regards,
Community Support Team _ Zeon Zheng

[Anonymous]

That sorted the issue, thank you!!

[Anonymous]

You are a genius! 
Thank you so much!

[v-angzheng-msft]

Hi, @Anonymous 

This is explained as a one-to-one and one-to-many relationship for the convenience of understanding. It refers to the mapping relationship between your rolling column and the value of the sorting column, rather than establishing a relationship for different tables in the model.
I am not clear about your data model. The mapping relationship between your rolling column and the sorting column value is determined by the column value, which depends on the value generated by your rolling column formula.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StefanoGrimaldi]

hello, 

1) first check the sorting column you using as reference its in number format

2) you can just sort the table by the same column month and will have the same effect, now if you want a more organize sort, sort by the entire date, if what you want its all the data of the table sorted on that particually fiel do it on the same column refence for sorting and there should be fine