Solved: Re: Sort column with error

Anonymous · ‎08-08-2023

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 · ‎08-08-2023

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

View solution in original post

mlsx4 · ‎08-08-2023

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 · ‎08-09-2023

Thannnnnnnnks so much now everthing is ok

ToddChitt · ‎08-08-2023

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.

Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!