Forum Discussion

dogt1225's avatar
dogt1225
Icon for Helper III rankHelper III
2 years ago

Continuous 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 mon...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.