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.
Create your Month-Year field differently to make it a proper date, then it will sort correctly. If you are extracting from a date field, do it like this:
date(MonthStart(datefield), 'MMM-YYYY') as [Month-Year]
Or use Dual Function like Dual([Month Year],DateNum)