I have a multi-series bar chart where I need to have the ‘Fill Gaps in Chart Data’ enabled. If it's not enabled, the red items display sequentially instead of in the correct month. The problem is the chart items are sorted alphabetically because of the Sort Order identified in the Multi-Series Chart Data attribute section. I need this data to be sorted by fiscal year. For example, October 22 should be the first item on the chart, followed by November 22, December 22, January 23, etc. How do I override the default sort? I've tried doing this within the query, but it is ignored because of this setting.
