Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a line chart for monthly data from Dec-15,Jan-16,Feb-16,......Sep-16.
When I select any SalesDate value , my graph should not be changed the order from Dec,Jan,Feb,Mar,.....Sep.
Please advise.
Thanks in advance.
Sort by Expression
Only({1}Match(Month,'Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov'))
Go to Sort Tab
Untick Sort By Expression (Date)
Tick Numeric Value
Thank You mrkachhiaimp.
If I do same, Dec going to last value. I want it first value in the sequence.
See if the attached works for you...
Sort by Expression
Only({1}Match(Month,'Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov'))
Hi,
You can use MonthYear as dimension, if you just display Month alone it will be confusing for users.
Hope this helps you.
Regards,
Jagan.
Hi,
Remove the Sort Expression and try.
Regards,
Jagan.