Forum Discussion
Fiscal Date sort for line graph
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
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:
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.
4 Replies
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/1187441I have given all 12 month start calendar with correct month sort
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.
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:
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.
