Forum Discussion

zidek22's avatar
zidek22
Frequent Visitor
6 years ago

Error cyclic dependency when sorting by calculated column.

Hello data wizards,   I have this problem in Power BI desktop. I need to sort months in a matrix according to their year. The months go like this:   Jan, Feb, Mar, Apr, May, Dec   the December ...
Need Help
zidek22's avatar
zidek22
Frequent Visitor
6 years ago

Thank you for your reply amitchandak !

 

I have a base column and I made one derived column. Then I highlight the base column and click "sort by column" and choose the derived column. I've already done this in a different project where I needed to sort months chronologicaly and not alphabeticaly and it worked great. I'm probably just doing some small mistake. Anyway, thank you for your time!

amitchandak's avatar
amitchandak
Super User
6 years ago

zidek22 , I have given formulas in last update to sort the month on month order, not the text. Just adjust to your table and that will work

  • zidek22's avatar
    zidek22
    Frequent Visitor
    6 years ago

    It worked! I added a second DateView column that I use to display the dates, then I created the DateSort column that is in a YYYYMM format and can be sorted. After that I sorted the DateView column by the DateSort column. Basicaly I never use the original Date column in my visual. Just writing this up for future reference if anyone needs it.

     

    Thank you so much! Bye amitchandak