Forum Discussion
Table shows different sortorder
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?
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.
2 Replies
Strange the numericsorting is pulled through to a visual, but: worked like a charm!
Thank you.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.
