Mixed Chart: metrics and columns are hidden

[propellerjet]

Bug description

Description: after creating Mixed chart metrics and columns on the side bar are hidden, message "ineligible item(s) are hidden" (screenshot №1) How to reproduce:

1. open datasets
2. choose dataset and click on it
3. in chart window click "View all charts"
4. choose mixed chart -> Select

After opening Query A or Query B metrics and columns appear (screenshot №2)

Screenshots/recordings

1. 

2. 

Superset version

4.0.2

Python version

I don't know

Node version

I don't know

Browser

Chrome

Additional context

No response

Checklist

• [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
• [X] 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[bot]]

The message "ineligible item(s) are hidden" in the Mixed Chart sidebar appears when there are metrics or columns that are not displayed due to being hidden by default. This happens when the hiddenMetricCount or hiddenColumnCount is greater than zero, indicating that some items are not shown because they exceed the default maximum length or are collapsed ^[1][2].

When you open Query A or Query B, the metrics and columns become visible because these sections are expanded, allowing you to see and configure the items that were previously hidden. This behavior is part of the design to manage the display of items in the sidebar efficiently.

To continue talking to Dosu, mention @dosu.