cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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?

 

Selecting the 'Sort by ABC' option to get the data to go from A to ZSelecting the 'Sort by ABC' option to get the data to go from A to ZThe graph doesn't sort according to ABC, instead it shows descending valuesThe graph doesn't sort according to ABC, instead it shows descending valuesTrying to select the ABC alternative again, it will sort the data alphabetically, but from Z to A.Trying to select the ABC alternative again, it will sort the data alphabetically, but from Z to A.

1 ACCEPTED SOLUTION
Microsoft
Microsoft

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Microsoft
Microsoft

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

 

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 🙂

 

br,

 

Kim

Great tip, thanks Dale!!

New Member

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.

I just tested and mine is working fine, as expected




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors