Year Ordering On Bar Chart Visual

Question

Good Morning,&nbsp;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.&nbsp;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?&nbsp;&nbsp;Thanks,&nbsp;

freemanz · Answer

Hi&nbsp;pigsinblankets&nbsp;Instead of adding a prefix,&nbsp;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-desktophttps://community.powerbi.com/t5/Desktop/Sorting-the-axis/m-p/674036

pigsinblankets · Answer

Hi&nbsp;FreemanZ&nbsp;- thank you for such a quick response,&nbsp;&nbsp;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.&nbsp;&nbsp;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?&nbsp;Thanks&nbsp;&nbsp;&nbsp;

Forum Discussion

Year Ordering On Bar Chart Visual

2 Replies

Related content

Order Log / Chart improved visualization

P6-Gantt Chart Visual

Bar chart Column Order

Sort dates in month order for bar chart visual

V-Order & Z-Order