Forum Discussion
Sort years in chronological order
Sorry, I know it is not a new topic but I want to understand if there is a simple way to do it.
Is there a way to sort years chronogically? Only creating new columns?
Ordering is a big issue for me. In PBI Desktop I am only able to sort decreasingly, whatever variable, I have not the option to sort increasingly, while I can do it when I publish the report in PBI Service.
Why?
Thank you so much
Hi nick93,
Click the left part which I have circled in red color, do not click the text.
Regards,
Jimmy Tao
11 Replies
- Greg_Deckler
Community Champion
Are your years numeric? Generally, if you sort by a column and then sort by that column again it reverses the direction of the sort.
Greg_Deckler thank you for answering, you are right, my years where memorized as text, but changing them to numbers gives me a new issue: all the visuals now are ok excepting filters, which still are in bad order (2017, 2016, ...). How can I fix it?
Moreover, text filters are ok (sort alphabetically), tables are ok too, while histograms are in the opposite order (for example, Wine comes first than Water). Why?
v-yuta-msftCommunity Support
v-yuta-msft thanks for answering!
Unfortunately, that doesn't solve my issue. My visuals get not updated the way I want, only my Query Editor tables get updated, but they were yet.
- v-yuta-msft
Hi nick93,
In a chart(e.g.: table chart), you can click the ellipse on the right-top corner, then click sort by date. You can also click sort by date again to change the order.
Regards,
Jimmy Tao
