Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
PuzzledSpark
Frequent Visitor

x-axis sorting incorrectly

I have a field called payment bucket that I calculate in SQL. When I drop ot into PowerBI it sorts it in the correct alphabetical order.

a) <-16  come first

then

b) -11 to -15 

 

and so on

 

Now I calculated the same field but using the Grouping capability of Power BI.

When i drop this into the same chart the axis is in reverse alphabetical order:

k) 16+

j) 11 to 15

 

and so on. Why is this and how do I fix it?

 

 

1 ACCEPTED SOLUTION
PuzzledSpark
Frequent Visitor

Ah I figured it out. For anyone searching - in the top right of the chart after clicking on ...

instead of clicking on the text portion that says 'Sort by ...' move the mouse cursor a little to the left and click on the Z->A  to change the ordering.

 

Wasn't immediately obvious that this was a distinct place to click on.

View solution in original post

1 REPLY 1
PuzzledSpark
Frequent Visitor

Ah I figured it out. For anyone searching - in the top right of the chart after clicking on ...

instead of clicking on the text portion that says 'Sort by ...' move the mouse cursor a little to the left and click on the Z->A  to change the ordering.

 

Wasn't immediately obvious that this was a distinct place to click on.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.