Sort A to Z impossible

[lassuied]

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 !

 

[swise001]

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.  

[lassuied · Accepted solution]

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 !

[swise001]

I opened an issue about this.  Please go vote it up so Microsoft is aware of the problem. 

https://community.powerbi.com/t5/Issues/Cannot-Select-A-gt-Z-Sorting-in-Chart-Visualizations-May-201...

[GilbertQ]

Thanks for letting us know

[v-shex-msft]

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

[lassuied]

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.

[GilbertQ]

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 Z

[lassuied]

Hello ! 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 ...