Forum Discussion
pigsinblankets
3 years agoHelper II
Year 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
3 years agoSuper User
Instead 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
- pigsinblankets3 years agoHelper II
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