Year Ordering On Bar Chart Visual

[pigsinblankets]

Good Morning,

Bit of a strange one, the years on my bar chart down the Y-Axis are not showing in order, they were and nothing has been touched or changed but randomly are now showing out of order.

I have added numbers preceding each year which usually works as per the below screenshot however 2026/27 is still showing out of order, is this a strange bug that happens occasionally and is there an easy fix that I'm probably missing this Monday morning? 

Thanks,

[FreemanZ]

Hi @pigsinblankets 

Instead of adding a prefix, you can sort the axis by other columns. check this:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

https://community.powerbi.com/t5/Desktop/Sorting-the-axis/m-p/674036

[pigsinblankets]

Hi @FreemanZ - thank you for such a quick response, 

I have created a custom column now with the year order as 1,2,3,4 however the chart is still showing them as 1,2,4,3 as per the below screenshot. 

Really confused with this one as I've never had this problem/issue before on lots of different charts, is there something else I can do in the data view/power query to fix this?

Thanks