I am looking to present a sequence of data points each attached to a date. I am looking to group them by month and present them in date order. The dates start in May last year and end in June this year Unfortunately when I try and present it using a line chart I can either view by year or by month - and when I view by month I cannot start the chart at the first month - it always starts in January. How can I filter by month and have months display consecutively, rather than merging them across years?

RobFlandersWhen you remove the year from the Date you are now asking to only see things in Month buckets so data from every Month of January will be groupd, every February etc, so in your case the values from May of 16 and May of 17 will be combined together in the 'May' data point.If you stick with the Line chart with Year and Month levels selected and then use the Drill Down arrow you can go to the next level down. Be sure you use the correct Drill Down option!!!