Forum Discussion
Sort A to Z impossible
Hello,
I am having an issue with sorting an axis for my chart... It is sorted by default Z to A and when I click it again it changes the sorting for amounts ... I cannot have my months to start by 01 like I use to... is it a desktop bug?
Thank you !
For information, I tried it on an older version from a coworker and it's working perfectly fine. The newer version has a bug.
Thank you for your help !
8 Replies
- Hi there, first question is your COD_Period column data type set to Whole Number?
If it is, then when you want to change the Sort Order, you actually have to click on the Z to A on the actual icon, and not on the name for it to then sort A to ZHello ! Thank you for your reply, the months are not stored as numbers (because I need the 0 as first character between January and September).
What I do not understand is that I've never had the issue before, when I was clicking on A to Z it was sorted Z to A and when clicking on Z to A it went back to A to Z ...
I aslo have the same issue for amounts ... Something changed in the new desktop version... Below is a screenshot of a chart made few month ago ... Now if I am trying to sort by month it messes up everything ... I am just trying to report a bug ...
HI lassuied,
Maybe you can try to add a category column for current group, then modify 'sort by column' properties to change its sort order.
Sort by column in Power BI Desktop
Regards,
Xiaoxin Sheng
Hello Xiaoxin,
I am just trying to report a bug from a newer version of Power BI. I was able to do this sorting before with no issue. Now I cannot do it anymore.
For information, I tried it on an older version from a coworker and it's working perfectly fine. The newer version has a bug.
Thank you for your help !
- Thanks for letting us know
I opened an issue about this. Please go vote it up so Microsoft is aware of the problem.
I'm experiencing the same issue as well.
I am unable to achieve a sort of A to Z on any Chart features.... only Z-A works.
This appears to be from the May 2018 update.
