SSRS - Sorting Series by value In a Stacked Bar chart

Question

I have a dataset that I'm representing as a stacked bar chart. I want to order each series by it's value (See image)

The ordering works as expected in the first column, however proceeding columns maintain the order of the last, regardless of their value.

Is this possible in SSRS? Im current sorting the series by value.

Answer 1

Thanks for your responses. I fixed the issue by utilising the following SQL to seperate each category group to have its own order.

SELECT Row_number() 
     OVER ( 
       partition BY createddate 
       ORDER BY Count(loggedrecid)) AS Col_group, 
   Count(loggedrecid), 
   createddate, 
   ownerteam 
FROM   @allrequests 
WHERE  faculty IN ( @faculty ) 
GROUP  BY createddate, 
      ownerteam 
ORDER  BY createddate ASC 

I then added Col_group as the Series group and ordered it by Col_group

All working as expected! Thanks for the assistance.