Line chart issues

[Vince_CH]

Hello Community,

I have a linechart like below, with dimension in YearMonth, which couldn't be ranked in sequence automatically, i tried other options in the property ranked by number or letter, but still doens't work out,  do you know how to fix it?

Also on the bottom of chart, there is a minichart, which I want to hide, is it possible? thank you.

[jheasley]

sort it by expression:

Min(Date(FISCALYEARMONTH,'YYYY-MMM'))

you many need to play around with the formating of the date, or possible use date#() instead.

[Vince_CH]

thanks, i used date#() trying with fiscal year and fiscal month combination. It worked with in similar calendar sequence from Jan to Dec, whereas my expectation is something like: Jul-2019, Aug-2019,Sep-2019,Oct-2019,Nov-2019,Dec-2019,Jan-2019....till Jun-2019.