Reply
Frequent Visitor
Posts: 7
Registered: ‎02-22-2018
Accepted Solution

Sorting in charts not working after April 18 update

I'm currently running Version: 2.57.5068.501 64-bit (April 2018), and noticed a bug when sorting a graph according to categories.

 

See the example graph below. If i want to sort my data according to the x-axis from A to Z, i would push the 'Sort by ABC' alternative, and the data should go from A, B, C etc... 

 

But Power BI doesn't sort the data alphabetically, instead it sorts it according to descending numeric values. If i try to select 'Sort by ABC' again it will sort the data alphabetically, but from Z to A instead of the other way around. If i try to sort again according to ABC, it will sort it in descending values.

 

Can somebody verify if they have the same problem? Is there a way to get around this issue?

 

1.jpgSelecting the 'Sort by ABC' option to get the data to go from A to Z2.JPGThe graph doesn't sort according to ABC, instead it shows descending values3.JPGTrying to select the ABC alternative again, it will sort the data alphabetically, but from Z to A.


Accepted Solutions
Community Support Team
Posts: 4,139
Registered: ‎05-02-2017

Re: Sorting in charts not working after April 18 update

Hi @kimmend,

 

That's just a little trick. When you click the "Sort by ABC", it will be highlighted. Then you can click the little icon in the head to switch sorting orders.

Sorting_in_charts_not_working_after_April_18_update

 

Best Regards,

Dale

View solution in original post


All Replies
Frequent Visitor
Posts: 2
Registered: ‎12-12-2016

Re: Sorting in charts not working after April 18 update

Im having the same issue with 100% stacked, its only allowing me to sort x-axis desc rather than being able to toggle between asc and desc.

Super User
Posts: 1,922
Registered: ‎06-24-2015

Re: Sorting in charts not working after April 18 update

I just tested and mine is working fine, as expected
Community Support Team
Posts: 4,139
Registered: ‎05-02-2017

Re: Sorting in charts not working after April 18 update

Hi @kimmend,

 

That's just a little trick. When you click the "Sort by ABC", it will be highlighted. Then you can click the little icon in the head to switch sorting orders.

Sorting_in_charts_not_working_after_April_18_update

 

Best Regards,

Dale

Frequent Visitor
Posts: 2
Registered: ‎12-12-2016

Re: Sorting in charts not working after April 18 update

Great tip, thanks Dale!!

Highlighted
Frequent Visitor
Posts: 7
Registered: ‎02-22-2018

Re: Sorting in charts not working after April 18 update

Thanks @v-jiascu-msft, this was too easy, now I feel a bit stupid.. Smiley Happy 

 

I have a feeling that something has changed in this area in the update, because before you could select the 'Sort by ABC' again, and it would switch between ascending and descending sorting.

 

Anyhow, I kinda like the way it works now that I know about it Smiley Happy

 

br,

 

Kim