Custom Date sort by Company Finanical Year

[LeeC2C]

Hi,

I hope this wonderful community could help me,

Our Company financial year starts from Nov and ends in Oct, I've managed to be able to filter on financial year with a custom column.

I'm fairly new with Power BI and seeing how it could improve our reporting. I showed my manager, and they asked could we have the graphs that uses date months to show yearly figures be aligned with our finanical year (Nov-Oct) rather than calendar (Jan-Dec).

I've looked around on the forums but couldn't find anything simular.

If anyone has ideas, I'm more than happy to try them out.

Thank you in advance,

Lee

[v-lili6-msft · Accepted solution]

hi, @LeeC2C 

Yes, you could get it by "Sort by column in Power BI Desktop".

Just add a financial year month column (if there is no this column in your financial calendar) then use sort by it.

Best Regards,

Lin