Forum Discussion
About the effect of sorting powerquery
Anonymous ,
Sort order of the output file depends on the sort of the visual.
The sort order of the visual can be adjusted like below, clicking on the ellipses and then choose the sort type accordingly.
Appreciate your kudos !! Mark this post as solution if this helps.
Hi Anonymous ,
The sorting order in Power Query only controls the sort order in Data Model of Power BI Desktop.
It doesnot control the sorting of any visual.
Appreciate your kudos!! Please mark my post as solution if this helps.
Thank you for answering!
Then, is it correct to recognize that the data order of the output file reflects the setting order of Powerbi desktop?
The file currently being created is sorted by both powerquery and powerbi desktop, and I'm thinking of deleting the sort of powerquery if the processing is wasted.
Anonymous ,
Sort order of the output file depends on the sort of the visual.
The sort order of the visual can be adjusted like below, clicking on the ellipses and then choose the sort type accordingly.
Appreciate your kudos !! Mark this post as solution if this helps.