8 Replies Latest reply on Nov 28, 2016 6:14 PM by Vishal D

    Year-Month chart sorting issue

    Vishal D

      I have below 3 fields coming from database HANA


      [Year] = [2016,2015,2014,2013]

      [Month] = [1,2,3,4,5,6,7,8,9,10,11,12]

      [Sales] = [123,654,789,234,......]


      I created [Year-Month] calc field but it does not plot in order.


      [Year-Month] calc field = STR([Report Year]) + '-' + DATENAME('month',DATE('2000-'+[Report Month]+'-01'))


      I want 2010-Jan, 2010-Feb ... to 2010-Dec but looks like the time slice is not sorting ok. The default is alphabetically by month. I want both by year-month