Stack bar chart not working with data from MS SQL

Hi All

I would like to create a stack bar chart and I have enabled option of stack.

but why not show a single bar for a categories?

my query as below

Can someone please help me out ?

Thanks

I think I figured it out.
stack chart can’t support series mode right?
image

hi,i have the same question.Do you fix it?