FY in axis not in order

[Anonymous]

hi all,

I am trying to get the visual to display by FY in chronological order (FY15, FY16 etc...)

I tried to sort by FY but it doesnt seem to work.
The FY is based on a calculated column.

Any hints?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can try to use “More options” – “Sort by”, set the FY column, then set it “Sort ascending” to arrange in chronological like following pictures.

BTW, pbix as attached.

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.