Table shows different sortorder

[Lex_i]

Hi all,

I've got a problem that seems simple, but I can't find the solution.

In PowerQueryEditor I sort imported data on three columns. Sorting is the last step en the result is as expected. However, in the table visual of that same data, the sorting order is different. There's is no sorting definition in the table visual. 

How to keep the sorting order in the table same as defined in PowerQueryEditor?

[Lex_i]

Strange the numericsorting is pulled through to a visual, but: worked like a charm!
Thank you.

[TotunG · Accepted solution]

Best way to do it is using say a Sort Number Value column (maybe like an Index colum once sorted going from 1-100) This way Power BI will sort them in a numeric way which should pull through on your Visual.