Need Help with Sorting Matrix Header Sequence

[NickProp28]

Dear community, 

I am facing an issues while trying to sort my matrix header sequence

What I am trying to achieve is to display my matrix header sequence starting from Current, 1 period, 2 period, 3 period, 4 period, and then Total. I have tried creating a new table and setting up the desired sequence, but I am encountering a circular dependency error when I try to sort by column.

Greatly appreciate any guidance or help that you can provide to solve this issue. If it is possible, please find my pbix file attached for your reference.

Pbix : https://drive.google.com/file/d/1jOZrjlTcDxJL3AQ15kBX8y4IYOGpoYIg/view?usp=share_link

Thank you in advance for your time and assistance!

[amitchandak]

@NickProp28 , If you same column to drive the Sort column you will get that , do it like

Col 1 = [Col]

Col sort =  <Sort logic based on Col>

Then Mark Col Sort as Col1 Sort column and use col1 in visual

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