Description of problem:

see the attached video:

https://drive.google.com/file/d/11wGiJGzh-wMduWTy2-qY59YzucXqPyLX/view?usp=sharing

admin user, go to "Observe -> Metrics", click "Add query" button, the first query result is NaN, example

scalar(kube_resourcequota{cluster="", namespace="test222", type="hard",resource="requests.memory"})

the second query result is not NaN, example: 222

click "Run queries" button to get the result, then click "Stacked" checkbox, the graph will be stacked, no issue.

if we change the query order, first query is 222, second query is the NaN query

scalar(kube_resourcequota{cluster="", namespace="test222", type="hard",resource="requests.memory"})

click "Run queries" button to get the result, then click "Stacked" checkbox, the graph will be hidden, graph is not stacked.

also tried with multiple search, if the first query is NaN, the second is not NaN, the third is NaN, click "Stacked" checkbox, the graph will be always hidden.
Version-Release number of selected component (if applicable):

4.16.0-0.nightly-2024-04-08-024331

How reproducible:

always

Steps to Reproduce:

1. see the description

Actual results:

multiple queries, if the NaN query is not the first query, click "Stacked" checkbox, the graph will be always hidden

Expected results:

graph should be stacked, not hidden