Forum Discussion

ryaneire's avatar
ryaneire
Regular Visitor
3 years ago
Solved

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 sc...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
ryaneire
Regular Visitor
3 years ago

Excellent thanks that worked perfect.