Forum Discussion
Helper IIIContinuous X Axis Line Chart with custom Fiscal Calendar
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
2 Replies
- Ashish_Mathur
Super User
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.
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.
