Sort column with error

[Anonymous]

Hi all!!!
Can you help me with a simple question 
I have this table and I need sort according with another classification 

but I have this erros when I sort kpi in order

Thannnnks

[mlsx4 · Accepted solution]

Hi @Anonymous 

The problem is that you have several values repeated in the left part (Pontos distribuidos MKT for instance). Therefore, when it tries to order, power bi finds that you have value 4 and 10, so it cannot order. You should try to create a combined colum with kpi and grupo, to be able to order by this new column

[Anonymous]

Thannnnnnnnks so much now everthing is ok

[ToddChitt]

Select the kpi column, then on the Column Tools menu, look for "Sort by column" tool. From there you can assign the column "order" to be used to sort kpi.