Year Sort on Clustered Column Chart

Hi, Anonymous 

Sorry that I could not find a way to sort the Attribute column by writing measure.

So, I created a reverse index column in Power Query Editor.

Please check the below link.

https://www.dropbox.com/s/e2yqo7kyupk3knl/Sample%20Data.pbix?dl=0 

Hi, Anonymous 

I'm pretty sure that the idea of creating a sorting column is completely correct, but there is a problem here.

Your sorting column is calculated based on the year column, and then the year column is sorted based on the sorting column.

This will cause a circular dependency, which cannot be supported.

You can try to create an index table in Power Query to create a sorting column by merging.

As Kim did, if that doesn’t work, you can try to create a sort hard-code in the data source, which is easy to make in Excel, and then import the data to Power BI

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

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.