Sort column with non-distinct values

[Anonymous]

Hi,

I have the data as below. Column2 is the display column and I want to sort it by Sort column. I am unable to sort as there are multiple columns with the same name There will always be only 1 template selected. Please let me know if we can achieve this in Power BI

Template	Column2	Sort
Template1	Value1	1
Template1	Value2	2
Template1	Value3	3
Template2	Value2	1
Template2	Value3	2

Thanks in Advance

[parry2k]

@Anonymous sort value for value 2 and value 3 is different in bottom two rows, if these have the same sort value, it will work. basically column you are sorting and the value you are sorting by should be unique

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

@parry2k , Template + Column2 is a unique value as we always query only on 1 Template. The display column is only the Display Column