circular reference in sorting year descending

db042190 , Create two columns

XYear1 = [XYear]

Rank = RANKX('mytable','mytable'[XYear],,DESC,Dense)

Then sort XYear1 on rank and use XYear1 in the visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Hi db042190 ,

A circular dependency is detected whenever two objects reference each other, in such a way that Power BI cannot process the objects. 

Based on my research, there are normally two ways to solve the circular dependency issue:

• Add the row identifier column to one of your fact tables, then create corresponding relationships with other fact tables.
• Use ALLEXCEPT to remove the calculated columns from the set of columns that become part of the dependency list is a viable option.

For more details about the circular dependency issue, you can refer to this article.

And you also could refer the following article:

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/ 

Did I answer your question? Mark my post as a solution!And if question not solved ,could you share your sample data?

Best Regards

Lucien