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: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

swise001

Cannot Select A-->Z Sorting in Chart Visualizations (May 2018 Update)

Submitted by Continued Contributor on ‎05-11-2018 05:35 AM

The A-->Z sorting option is not working in Chart Visualizations in the May 2018 update.  Despite multiple attempts, the sort feature seems locked to Z--->A only.  

 

This is highly disruptive as all charts are now defaulting to Z--->A sorting and cannot be set to A--->Z.

 

Sort.pngSort2.png

Status: Needs Info
See more ideas labeled with:
16 Comments (16 New)
Comments
Anonymous
Not applicable
‎05-11-2018 10:16 AM

I have to point out that this is happening on dates as well. Sorting by dates is not "sticking" and the visuals keep reverting to a sort by Sales Amt. This is even with defined sorting in my dataset and has worked before the recent updates.

 

sort-service-erroragain.png

 

 

 

v-qiuyu-msft
Community Support
Community Support
‎05-14-2018 01:27 AM

Hi @swise001,

 

I'm not able to reproduce the issue, when you try to change sort order, please click on the highlighted button: 

q3.PNGq4.PNG

 

@Anonymous Would you please share a pbix file for us to reproduce the issue? Is there any step you take then the chart reverts to a sort by Sales Amt.? 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎05-14-2018 01:28 AM
Status changed to: Needs Info
 
swise001
Continued Contributor
Continued Contributor
‎05-14-2018 03:51 AM

@v-qiuyu-msft

 

Here is a sample PBIX file that exhibits the axis problem.   The issue reproduced into this file (which I made this morning using manually entered data only). 

 

Sample PBIX File

Anonymous
Not applicable
‎05-14-2018 06:18 AM

@v-qiuyu-msft

Unfortunately I cannot share a pbix file, though I am not experiencing this on the desktop. I can sort everything fine while on the desktop and it "sticks" in the correct location. The problem I have is when I publish to the Service the visual reverts to a different sorting method. For me, this only occurs on the Service.

francisco
Regular Visitor
‎05-14-2018 08:24 AM

Click te icon (A->Z), no the text.

I think is a error, yes.

swise001
Continued Contributor
Continued Contributor
‎05-14-2018 08:42 AM

 

 

Here's a gif of what is occuring in the sample file. 

You'll notice the the A--Z option doesn't show.

giphy

 

v-qiuyu-msft
Community Support
Community Support
‎05-15-2018 12:28 AM

Hi @swise001,

 

I have looked into your pbix file, it's able to sort the order A->Z. please ensure you are clicking on the Z->A button instead of "Sort by <column name>". See: https://www.dropbox.com/s/cfvwl3wyyweyqvd/Sample_AxisIssue.pbix?dl=0

 

q5.PNG

 

@Anonymous Before you publishing the report, make sure you already save the sort change in Power BI desktop. 

 

Best Regards,
Qiuyun Yu 

swise001
Continued Contributor
Continued Contributor
‎05-15-2018 04:47 AM

@v-qiuyu-msft

 

Has that always been the case?  Shouldn't the behavior of clicking on the words "Sort by Grade" be the same as clicking on the letters "Z/A"?

 

Clicking on the letters does solve the problem, (Thank you) but also points out a major usability issue in how the sort responds based on where a user clicks.  I would imagine that whole line should yield the same sort result. 

 

 

Anonymous
Not applicable
‎05-15-2018 06:19 AM

@v-qiuyu-msft as I stated before, I have done this in the desktop and I have it also set up in my data model. I'm completely positive it isn't anything on my side that is causing this, but the 'improved default sort for visuals' that was introduced recently. Just from my observation, I believe that the Service is prioritizing "Measure" based sorting methods rather than "Column" based sorting.

Idea Statuses