Sort the year bucket of work experience 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

[amitchandak]

@Enan , to avoid that create a new column

Exp (group) 1 = [Exp (Group])

and sort this new column on sort column and use that

or move the above logic in power query

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