Hi, since the April 2018 release, it is not possible to sort A-Z on a chart axis, only Z-A. When clicking A-Z on the dropdown elipses, nothing happens. It is possible to sort by a measure but not A-Z with a text value or numeric value on the axis.
I'm not able to reproduce the issue on my side. Please update the Power BI desktop to the latest version then test again.
Best Regards,Qiuyun Yu
Strange, I am running the same version on Win 10. Have you tried sorting by the measure and then trying to sort it again by A-Z? I am still having problems, I'll check with some colleagues and see if they have the same issue.
I tested again without reproducing the issue. Please clear data cache then test again.
I think i have the same issue
I did this by entering some basic data
Enter simple data
Create a column chart and if i use Sort by Category in the menu, the chart axis sorts Z-A
Sort by Category goes z-a
If I click Sort by Category again, it reverts to Sort by Value
Sort by category again, sorts by value
Click sort by category again and it does the same again - sorts by category Z-ASort by category again, sorts z-a
I should add that you can get to an A-Z ordered axis in my example eventually by continually clicking Sort by Category in the menu until it happens but there doesn't seem to be rhyme nor reason to it
I have this issue as well - even when creating a pbix from scratch.
Hmm, something really changed.
By default the axis is ordered by the value
It's still possible to order by the axis category.
Hope this helps
Excellent spot, thanks @TomMartens. That works for me as the dashboard developer, but it will still be an issue for end users. (Assuming the issue is the same on the service, not sure I've tested this)
Luckily we have a yammer group for all the Power BI users at my current client and also a dedicated support team for Power BI. I posted something about this "changing behavior" and also updated the support team, Until now we had just one support case that could be closed very fast, now we are waiting for the May magic 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.