Financial Year - Axis order

[ryaneire]

Hi,

I'm sure this is a relatively easy fix but cannot see how to do it.

I want to FY to be in consecutive order i.e 2017-2018, 2018-2019, 2019-2020, 2020-21 etc... 

As you can see from screenshot below the years aren't in order, can you tell me how I achieve this? 

Thanks,

[Anonymous · Accepted solution]

Hi @ryaneire ,

Please try below steps:

1. below is my test table

Table:

2. add a area chart with table fields, please don't sort axis by "Sale", sort the axis by "FY"

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryaneire]

Excellent thanks that worked perfect.

[arvindsingh802]

You can sort your FY column by a custom column 

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