@Jake_Powell The main point of having the X‑axis as a date field is to preserve its chronological order. Sorting options are therefore limited to cases where this order can be maintained. Here are the scenarios:
- Sorting by X‑axis (date): Supported, as it maintains chronological order.
- Sorting by legend name (per column): Currently alphabetical. To customize the order, create a custom dimension using a
CASE WHENas in this post and add a prefix (e.g.,a,b,c...or1,2,3...) to enforce your desired sequence. - Sorting by total Y‑axis by legend values across the x‑axis (e.g., total Yellow vs. total Blue vs… across x-axis): Not supported natively. Workaround:
- Calculate total values for each legend across the time range.
- Similar to the 2nd case, create a custom dimension with a
CASE WHENand prefix to match the desired order.
Note: This is a fixed sort captured at chart build time. If legend values change later, the order may no longer be correct.
I’ll pass this feedback along to the team for review.
Let me know if the above matches your use case or if you’d like to discuss further.