How to sort cloumn by custom?

[Anonymous]

How to sort column by custom

I want to sort column status by completed   error  cancel

Guide me please

[MFelix]

Hi @Anonymous ,

In this case you need to add an ID column that has one value per each one :

ID - Status

1 - Completed

2 - Error

3 - Cancel

On the query editor add a custom column with the following code:

if [status] = "Completed" then 1 else if [status] = "error" then 2 else 3

Then do a sort by

[Anonymous]

@MFelix if​ i​ want​ sort completetd, on​ the​ way, cancel​, error​, blank

Guide​ me​ please.

[MFelix]

The format is the same you just need to add additional syntax for each vbalue:

if [status] = "Completed" then 1 
else if [status] = "on the way" then 2 
else if [status] = "cancel" then 3
else if [status] = "error" then 4 else 5

[Anonymous]

@MFelix   I want to sort status completetd, on​ the​ way, cancel​, error​, blank.

and If status = on the way I want to sort progress lowest to highest

Guide me please.

[MFelix]

HI @Anonymous ,

For this you need to use the shift on the visualization table, you first sort by the Status and then keeping the SHIFT pressed you click on the progress

[Anonymous]

@MFelix​​ then keeping the SHIFT pressed you click on the progress.

Please​ explain​ to​ me, I​ DON'T​ understand.

[MFelix]

Hi @Anonymous ,

Check the link below with full explanation: 

https://www.c-sharpcorner.com/article/how-to-sort-a-table-using-multiple-columns-in-power-bi/#:~:text=Press%20Shift%20%2B%20Left%20Click%20on,on%20%E2%80%9COrder%20Date%E2%80%9D%20column.

[Anonymous]

@MFelix  If I want sort 2 option by step1 sort by status and sort by %progress.

Example if status = on the way , step 2 sort by %progress from ascending

Guide me please.

[Anonymous]

Hi @Anonymous ，

You can add one step in your Advanced Editor just like below screenshot:

#"Sorted Rows" = Table.Sort(#"Added Custom",{{"Custom", Order.Ascending}, {"%progress ", Order.Ascending}})​

Best Regards

[MFelix]

Hi @Anonymous ,

Is this sorting to be made on a table visualization?

[Anonymous]

@MFelix  No, I use stacked bar chart visualization.

[MFelix · Accepted solution]

On the tree dots of the bar you can select the sorting by percentage