Forum Discussion
pigsinblankets
Helper II
Helper IIYear Ordering On Bar Chart Visual
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...
FreemanZ
Super User
Super UserInstead of adding a prefix, you can sort the axis by other columns. check this:
https://community.powerbi.com/t5/Desktop/Sorting-the-axis/m-p/674036
pigsinblanketsHelper II
Helper IIHi 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