
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month name from January to December
Hi, I have a chart in which I have to show the data from the month of January to selected month.
My problem is my chart shows the months as expected however it starts from month of April. Actually, It should start from January as per calendar.
Please find attached screenshot & qvw file for reference.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this..
Dimension =Date(MakeDate(Year, Month, 1),'MMM YYYY')
and sort tab use default settings..
Hope it helps!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Sort it by Numerical value by Ascending order.
Thanks,
Naresh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Naresh, Thanks for your quick reply. Unfortunately the solution provided by you is not working.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Piyush,
Create this inline table in your script and Map your Month field with this table.
Month_1:
Load * INLINE [
MonthName, Month
Jan,1
Feb,2
Mar,3
Apr,4
May,5
Jun,6
Jul,7
Aug,8
Sep,9
Oct,10
Nov,11
Dec,12
];
It is better first create a separate field in your data model by concatenate 'Month' and 'Year' like MonthYear (Apr 2018, May 2018, Jun 2018 etc) and use that field in your chart.
After this in your chart-> go to Sort -> Sort by Expression (Ascending) =num(Month) and Numeric Value (Ascending)
Try this!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Prabir_c
Thanks for your kind reply. regarding this issue I have couple of charts, who are displaying correct month order like from Jan to Dec however for a specific char which is attached, it is not showing. could you please check the test file attached & check why it is not working for this chart. Rest of other charts it's showing in correct order.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this..
Dimension =Date(MakeDate(Year, Month, 1),'MMM YYYY')
and sort tab use default settings..
Hope it helps!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Qv_testing,
Thanks for your solution, my problem got solved.
