Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

SPMoore

AZ Sorting broken

Submitted by Advocate I on ‎04-24-2018 03:35 AM

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

Status: Needs Info
See more ideas labeled with:
13 Comments (13 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎04-25-2018 06:42 PM

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. 

 

q1.PNG

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎04-25-2018 06:43 PM
Status changed to: Needs Info
 
SPMoore
Advocate I
Advocate I
‎04-26-2018 01:56 AM

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-msft
Community Support
Community Support
‎04-28-2018 02:41 AM

Hi @SPMoore,

 

I tested again without reproducing the issue. Please clear data cache then test again. 

 

q7.PNG

 

 

Best Regards,
Qiuyun Yu 

saviourofdp
Advocate I
Advocate I
‎04-30-2018 08:30 AM

I think i have the same issue

VersionVersion

I did this by entering some basic data

Enter simple dataEnter 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-aSort by Category goes z-a

If I click Sort by Category again, it reverts to Sort by Value

Sort by category again, sorts by valueSort 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-aSort by category again, sorts z-a

saviourofdp
Advocate I
Advocate I
‎05-01-2018 12:42 AM

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

ross27
Advocate II
Advocate II
‎05-01-2018 01:12 AM

I have this issue as well - even when creating a pbix from scratch.

TomMartens
Super User
Super User
‎05-02-2018 03:11 AM

Hmm, something really changed.

By default the axis is ordered by the value

 

It's still possible to order by the axis category.

 

  1. Open the context menu of the chart
  2. Hit order by category (Click on the text)
    The axis will be ordered by the categories from Z (left)--> A (right)
  3. 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

ross27
Advocate II
Advocate II
‎05-02-2018 03:22 AM

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)

TomMartens
Super User
Super User
‎05-02-2018 03:33 AM

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 🙂

Idea Statuses