Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Column sorting

Hello everyone,

Why can't I initially sort the "KPI" column by the "ORDER" column, because of the repeated data?



But when I remove duplicates, I manage to sort.




And when I exclude the removal of duplicates, does the "KPI" column remain ordered by the "ORDER" column even with the duplicates?



Super User II
Super User II

Hi @XTF_2020 

if you want to sort KPI 1 by column Order which order should be taken 1 or 3? It's the same with KPI 2: 2 or 4?

The sort order must be distinct!


With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)




Hi @FrankAT 


The classification in this last image is correct, there are duplicates for the KPI, but they are different calculations.

My question is why the KPI column does not sort on the first attempt, but only when removing as duplicates and subsequently excluding a duplicate removal step with it left in order.

It looks like an interesting finding. I will probably use it as a trick in some sorting scenarios. Thanks. @XTF_2020 

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors