Sort the year bucket in Chronological order

[Enan]

Dear Expert,

Please help to sort the staff experience bucket (Years) in Chronological order for the graph.

I have made a new column in my fact table as "Sort_Year" by using DAX.

However when I used the "SORT by Column" option under column tools to sort the graph it gives circular dependency error.

Kindly assist.

Circular Reference ErrorDAX used to create calculated column in Fact TableGraph made using FACT table, Experience buckets and Count of Staff

[v-jianboli-msft · Accepted solution]

Hi @Enan ,

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

From the screenshot, it looks like you created your Sort column based on the original EXP(groups) column and want to rely on the created Sort column to sort the EXP(groups) column, which will create a circular dependency, please consider using a column unrelated to EXP(groups) to sort it. There is another simple way to create a Sort Column in PowerQuery

For more details, please refer to:

Avoiding circular dependency errors in DAX - SQLBI

Best Regards,

Jianbo Li

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

[DOLEARY85]

Hi,

when you say you created a column, how did you do that?

if you create a new table, create an order list for your fields, join this to the original table then bring this through the sort order to the current table as a calculated using something like calcualte(max(table name,order field name)) 

you should be able to sort on that,

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Enan]

Hi,

Thank you for the guidance,

However i did not understand, can you please explain.