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.
Simon
13 Comments
- v-qiuyu-msftCommunity Support
Hi SPMoore,
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 - Vicky_SongImpactful IndividualStatus changed:NewtoNeeds Info
- SPMooreAdvocate I
Hi v-qiuyu-msft
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.
Simon
- v-qiuyu-msftCommunity Support
Hi SPMoore,
I tested again without reproducing the issue. Please clear data cache then test again.
Best Regards,
Qiuyun Yu - saviourofdpAdvocate I
I think i have the same issue
Version
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
- saviourofdpAdvocate I
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
- ross27Advocate II
I have this issue as well - even when creating a pbix from scratch.
- TomMartensSuper User
Hmm, something really changed.
By default the axis is ordered by the value
It's still possible to order by the axis category.
- Open the context menu of the chart
- Hit order by category (Click on the text)
The axis will be ordered by the categories from Z (left)--> A (right) - Hit the small "Z->A" text/symbol left from the text "Sort by ..." and not the text again, this somehow toggles between sort by value and sort by category
Hope this helps
Tom
- ross27Advocate II
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)
- TomMartensSuper User
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 :-)