Forum Discussion

third_hicana's avatar
third_hicana
Helper IV
2 years ago
Solved

Sort Column Chart (Circular Dependency Error)

Hi All,   Asking for your help. I have a date column in my table named Project Completion Date. I created a calculated column to extract the year referencing the  Project Completion Date column usi...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi third_hicana 

    You just need to use year() function to extract the year, it will return the value with number type, then put the column to the x-axis, it will order automatically.

     

    Project_Completion_Date(YYYY) =
YEAR ( FY25_PB_Master_Data[Project Completion Date] )

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello third_hicana ,

 

create this as a custom column in power query 

Project_Completion_Date(YYYY) =
FORMAT(FY25_PB_Master_Data[Project Completion Date],"yyyy")
 
and then the second column you're creating should work normlly
  • third_hicana's avatar
    third_hicana
    Helper IV
    2 years ago

    Hi Idrissshatila 

     

    I got this error when I created another column in the Custom Column in Power Query

     

    • Idrissshatila's avatar
      Idrissshatila
      Super User
      2 years ago

      third_hicana ,

       

      yes , you can't copy paste the dax measure in power query since they're two different measures.

       

      so check it here to know how to extract the year from the date column.