When building a chart that’s colored by a pivoted dimension, you may see the legend sort order not match the pivoted field sort order.
To resolve this, you’ll want to fill in missing cells in grid to convert the null values to zeroes. Querying data | Omni Analytics Documentation
And then the chart legend order will match the pivoted field.
