Fiscal Date sort for line graph

[Anonymous]

The companies Fiscal year is October to Sept and I have the Fiscal Month working for all visuals on the report except Line Graph

I want to see left to right Oct, Nov, Dec............ Sept

But the only sort options I get are Value or Fiscal Month (Alphabetically) .... both of these do not meet the requirement 

I can use month number and offset, but I need the month name displayed 

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I guess that you want to make the data in your line chart be sorted by the Month number (left to right Oct, Nov, Dec............ Sept), I think you can create an index column for your [Fiscal Month] column and use the “Sort by column” function in Power BI to sort the data in the line chart, like this:

You can refer to this document:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column#sort-using-the-sort-by-column-button

If you can not figure out how to achieve your requirement using this function, you can post some sample data or your test pbix file(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can get the calendar and script at

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

I have given all 12 month start calendar with correct month sort

[Anonymous]

Thank you for your reply, I have managed to fix this issue last week with the help of Google

[v-robertq-msft]

Hi, @Anonymous 

Glad to hear that you have sloved your problem by yourself, would you like to share some experience and mark your own reply as a solution or just mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.