Continuous X Axis Line Chart with custom Fiscal Calendar

[dogt1225]

I am creating a line chart using a custom Fiscal calendar. Februrary is the start of the fiscal year and Janurary is the end of the fiscal year. I need to show a line chart of a rolling 13 fiscal months. 

I am hitting an issue where Janurary is separated from the rest of the data due to how in the fiscal calendar it is the last month. I tried using a sort but the lines are updated and not the position on the X axis. 

The X axis must be kept "Continuous" as I need to keep the trend lines. 

How do I show a continuous X axis where it would show Jan 2024 right after December 2024 and before Feb 2025. For example:
Feb-24 | Mar-24| Apr-24| May-24| Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-24 | Feb-25 | Mar-25 | Apr-25 .....

Fiscal Year - Month = 
    [Fiscal Year] & "-" & 'Date'[Fiscal Month Name]

(Fiscal Year - Month field is a 'Date' data type)

Fiscal Year - Month (sort) = 
'Date'[Fiscal Year] * 100 + 'Date'[Fiscal Month Number]

Fiscal Year - Month (sort) is used to sort the Fiscal Year - Month field

[Anonymous]

Hi @dogt1225 , Ashish_Mathur, thank you for your prompt reply!

In Power BI, for date-type column, the X-axis of the line chart is displayed in date order by default, which ensures the continuity of the time-series data.

If you want to reorder the dates or customize the ordering, we suggest you converts dates to a string.

Test result for your reference:

Best regards,

Joyce

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

[Ashish_Mathur]

Hi,

Ho can Jan-2024 appear after Dec-2024?  Shouldn't that be Jan-2025?  Also, share data in a format that can be pasted in an MS Excel file.  Show the expected result in a Table format.