Stacked Column Chart - Sorting

[Emmy66]

Hi,

Below is a sample of the stacked column chart I have, my intention is to have the highest first followed by the next one. Example below. My expected output is to have the first bar from the left (i.e. green first and followed by blue & also the red first before the green in the 2nd bar from the left etc) rather than what it's currently showing. Is this possible to achieve. Any help on this will be appreciated. 

[Anonymous]

Hey @Emmy66 , is this chart static? As in , does it get filtered by different slicers, see if it is static then I would recommend you to create an additional column in the backend source say a sorting column, and give it numbers 1,2,3,4 etc.' i.e. the way you want to sort the data, now post this change the data type of this column to number and in the table view sort this stacked legends by sorting column and it would appear like this, but if its dynamic that it wouldn't be possible.

Kindly mark this solution as accepted of this works fine with you.

[Emmy66]

Hi @Anonymous,thanks for your prompt response. The measure in the values field is calculated i.e. dynamically generated and not static. It seems like what I intend to achieve is not possible. Thank you so much for finding time to respond to my question.