Sort by column not working because of duplicate values, there are none

[BaltoLo]

Hello, i am trying to sort this Diagram

by the ThemenID of this table

Since it does not seem to happen automatically and sorting by decreasing put T10, T11, T12 and T13 before T2, I tried the Sort by column operator on Thema by ThemenID which throws the following error message

but there are no duplicate values between Thema and ThemenID.

Is there an easy solution for this or am even able to just sort the diagram by hand?

Thanks in advance

[Pragati11 · Accepted solution]

HI @BaltoLo ,

If I see your data there are duplicate values for THEMA column with more than one value in THEMAID column. See the screesnhot below:

So, in this situation how can you sort a value having 2 values in ID column.

Thanks,

Pragati

[BaltoLo]

I am a bit embarrassed that I did not see that myself after looking at it multiple times. Thanks. I looked up the problem in SQL and it seems like the second one has a backspace afterwards which is why there a two.

[Pragati11]

Hi @BaltoLo ,

Nothing to be embarassed about it. I myself tend to make similar mistakes looking at the data multiple times.

Glad you can fix it now.

Thanks,

Pragati

[amitchandak]

@BaltoLo , Looking at this data it should mark id as sort column.

Can you share a sample pbix after removing sensitive data.