Custom sorting based on sort order column

[Shailu198]

Hi All,

I have a column called Dsat which contains - Very Dissatisfaction, Dissatisfaction, Satisfaction & Very Satisfaction and a column called Osat which contains values to it. I created a column called sort order with values 1,2,3,4 respectively. Now, i want to sort the chart based on the sort order values. For which when i m trying to sort, a circular dependency error is appearing.  Need help to resolve the issue.

Regards,

Shailesh

[v-shex-msft]

Hi @Shailu198,

This issue often appears when you write multiple calculated columns/measures and reference between themselves.

Can you please share some detail content to test? It will be help for troubleshooting.

Regards,

Xiaoxin Sheng