Forum Discussion
Financial Year - Axis order
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,
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.
3 Replies
You can sort your FY column by a custom column
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.Excellent thanks that worked perfect.
