Hi all. Hoping someone has a good trick for this; I've exhausted all the suggestions I can find on it. Stacked bar chart component is sorted by a bucketed field. I don't really care whether it's 1 to 9 or vice versa but it's randomly out of order for stages in between. I've tried renaming both the stages and the buckets with 1, 2 or 01., 02. etc but it still won't behave. I know this has been a weird bug for a while but wondering if anyone cracked it. I even tried a sort order formula field to force it but no luck.
New finding: It has something to do with adding the secondary measure. You add your component, select the chart type, set the axis = Legend/chart bar stacks are fine. As soon as you click + measure
(even before selecting which one), the legend order changes. Odd behaviour = how do we circumvent this?
Please see screen shot - why won't #5 behave? Thanks.
