Sort column by value

[Sophie_]

Hello,

 i want to sort my column partner_display by ecart_max

when i try to do it by sorting i got this message :

How can i sort my column by value ?

Reagrds,

Sophie

[SamWiseOwl]

Hi @Sophie_ 

Could you split these two columns into a seperate table. 
Remove duplicates and then apply your sort.

Then join back to your original visual. That would remove the error as the seperate table is unique.

If you are using a chart visual, it is possibel to sort using a measure.

Create a measure that returns the MAX ID and put it in the tooltip. On the visual apply a sort.

For anyone interested:
“Sort by another column. We cannot sort the column ‘partner_display’ by ‘ecart_max’. You cannot have multiple values in ‘ecart_max’ for the same value in ‘partner_display’. Choose another column to sort or update the data in ‘ecart_max’

[Sophie_]

Hello @SamWiseOwl ,

do you have an exemple to di this : "

Remove duplicates and then apply your sort.

Then join back to your original visual. That would remove the error as the seperate table is unique." ?

I want to sort partner_display in filter.

Sophie

[SamWiseOwl · Accepted solution]

Hi @Sophie_ 

In the Query Editor (Transform data) go to your table and choose reference.

Then highlight the two columns to keep and choose remove other columns. Then choose Remove duplicates

Join this back onto your table in the front end and use this column instead of the original.