Custom Sorting

[smithmc3]

So I am trying to sort based on Submission Status  and want to show the status in sequence order.  Additionally, we have developed slightly different names that we want to display for users.  I created a separate table to relate the old name (OName) to the new name (NNAme) and put in another column for the order in which we want them to show (Order).  

I could not get it to sort based on the Order column no matter how I added it.  As a temporary work around I added it to the NName column as shown above.  Any thoughts on how I can get it to sort by the order column?

[Sean · Accepted solution]

select the OName column - Modeling Tab - click Sort By Column - select Order from the dropdown

[v-caliao-msft · Accepted solution]

Hi @smithmc3,

Please refer to the screenshot below to change oders of you Axis items.

Regards,

Charlie Liao

[smithmc3]

So, I tried that and it stays the same, thoughts?

[smithmc3]

Thanks guys! I refreshed the data a few times and saved and now it seems to be working! 

[Sean · Accepted solution]

select the OName column - Modeling Tab - click Sort By Column - select Order from the dropdown