I have a line chart with two dimensions, Month & Year. However, on the first year the data only starts in July so the legend is not sorted correctly. On our actual data the problem is even worse as many of the years have only got data for a few months (and not necessarily starting in January). I understand the why, but was wondering if there was an obvious fix I was missing. Below is a simplified example of the problem. I'd like the legend to be sorted correctly.
Thanks for the feedback Ralf, I might have understated the problem. Some of my years don't have data for the last few months either. So even reversing it doesn't work. Hopefully we'll see a feature add or some other way to do this soon. I don't think it's that unusual a requirement.
Thanks again for the efforts Ralf. You got my hopes up there. If I correct the month sort order though it seems to lose it again (Unless I misunderstood your method). I note yours is running from December. I think that Sense is iterating through the first dimensions values to retrieve the associated values in the second to display on the legend and so it appears in the order that they're discovered. It makes sense why they'd do it that way given that they want it to be lightweight, responsive and data driven rather than having collections which need to be updated for every selection.