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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
CarlDownUnder
Regular Visitor

Sort is reversed

Why is my field sorted in reverse?  Using the date field I created a column with financial year.  This sorts in reverse.  I created a field with just the year number.  If I use this it sorts in correct order, left to right.  I try to sort FY by year number, nothing changes?  Thanks.

Reverse sort.PNG

 

 

 

1 ACCEPTED SOLUTION

Hi,

Press again on the Z to A. It will change to A to Z and your data will be sorted

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

in the sort by, click the little arrow button  (it's tiny) and it shall reverse to the order you want. 

Anonymous
Not applicable

HI

 On the right top of the visuals click the options and change the sort order.

 

Thanks

Raj

No luck with either of those.

Only option I find there is Z to A.

PBI sort order to right.jpg

 

No options here.

PBI sort order sort by.jpg

 

Thanks

Hi,

Press again on the Z to A. It will change to A to Z and your data will be sorted

Thank you.  The thing that I didn't notice is that there are two clickable areas.  I thought each row was one option.

PBI sort order solution.jpg

Anonymous
Not applicable

The ZA and AZ options act as toggles.  Press the same option again and it should switch.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors
Top Kudoed Authors