Bar chart results & displayed data mismatch

[zuzana-vej]

Bug description

On a bar chart, returned results include results for 3 different dimensions, but on the bar chart visualization only 1 dimension is displayed.

Screenshots/recordings

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

This looks like it matches a confirmed bug where bar charts with dimensions (groupby fields) fail to sort correctly by metric — ECharts falls back to alphabetical ordering instead of the configured sort, which can make it appear that only some dimensions are displayed. The root cause is in the isMultiSeries logic in transformProps.ts that doesn't properly pass sorting configuration when dimensions are present [1].

This is tracked across several issues:

• Issue #34352 — primary tracking issue [2]
• Issue #38877 — same bug reported for Superset 5.0 [3]
• Discussion #38245 — detailed reproduction [4]

A fix exists in PR #37712 but has not been merged yet [5].

Workaround: Pre-sort your data in SQL using ROW_NUMBER() or a ranking function to encode the desired order as a numeric column, then set "X-Axis Sort By: Category name" in the chart config [6]. Note that the legacy Bar Chart workaround is no longer available in Superset 5.0+ since all legacy charts were removed [3].

That said — could you also check if you have a Series Limit configured in the chart that might be truncating results to a single dimension? That's a separate potential cause worth ruling out.

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.

[zuzana-vej]

additional context: "bug in echarts. When stacking, it can be seen that some parts are not being merged properly" when unstacked - using "stack style: none" it displays correctly