Starting X axis at April

[sparker22]

I have a line chart with monthly figures as well as by financial year in the legend.

Is it possible to have the X axis start at April rather than January?

[amitchandak · Accepted solution]

@sparker22 , Create a sort column like this

month = format([Date], "mmm")

Month Sort =

var _mn = month([Date])

return

if(_mn >=4, _mn -3, _mn+ 9)

Sort month on month sort

month year =  format([Date], "mmm-yyyy")

Month year sort =  [FY as Year] *100 + [Month sort] // [FY as Year] is taken from year start date