How to sort X Axis for aging in sequences

[Anonymous]

https://www.dropbox.com/s/k9f64gy5r945u59/AR_ISDN%20v009%20trail%20how%20to%20sort%20axis%20in%20seq...

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

You can try my steps:

1. Go to apply and close the PQE:

2. Then go to the column, do the “sort by column”:

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Hi Robert

Thank you very much , i learn one more thing.

Paul

[v-robertq-msft]

Hi, @Anonymous 

You can try my steps:

1. Click the [AGING] column,->"Sort by column"->"[AGING sort]", like this:

2. Then go to the visual, sort ascending, and you can get what you want, like this:

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Hi Robert

Your is running fine. 

Mine is not running , because when i try to click on Aging Sort :-

I get error msg below :-

Do you know where go wrong ?

Paul

[v-robertq-msft]

Hi, @Anonymous 

Why do you need to do this step in Power Query editor? Would you like to share your pbix link and explain your requirement in detail if you can't solve this problem?

Thanks in advance!

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Hi Robert

I try to duplicate you step , below is my file :-

https://www.dropbox.com/s/mvpf4q7505foh3l/PB_TDS_V043.pbix?dl=0

Pls let me what you do in detail , so i know where i miss out ?

Paul Yeo

[ryan_mayu]

@Anonymous 

sort by aging and sort ascending.

if you want to use Amit's solution, you can find sort by column under the column tools tab.

[Anonymous]

Hi Ryan

I have try to mark the sort by Aging Sort , it work fine now. 

But when i load more data , the sort does not work now.

[amitchandak]

@Anonymous , Created sort column. Marked as sort column. Correct Sort order on visual

Please find the attcahed file after signature

[Anonymous]

Hi Amit

Thank you very much. it work. 

Can you take a screen shot , how to mark as sort column ? i cannot find it.

Paul