Need to sort legend in 100% stacked column chart

[Dharma0208]

Hello everyone, I have the following stacket column chart, and I woukd like to sort the the percent values and is not working by the ordinary way. I only have the option below., and if the I choose market share asc or desc nothing happens, there's a way to put the the the larger number at the end and grow the stacked till the lowest?

X axis: Years column

Y axis: measure 

var uni = SUM(MDL_MKT_SHR_SLS_C2[Dimensions.CY_SLS_UNITS_QTY])

var totuni = CALCULATE(SUM(MDL_MKT_SHR_SLS_C2[Dimensions.CY_SLS_UNITS_QTY]),ALLSELECTED(MDL_MKT_SHR_SLS_C2[Dimensions.Manufacturer]))

             return

          DIVIDE(uni , totuni, 0)

 legend: Manufactuere column from table

[v-yetao1-msft]

Hi @Dharma0208 

You mentioned that "there's a way to put the the the larger number at the end and grow the stacked till the lowest?" , can you explain it in dertail ? Or you can describe your need through screenshot or video .

Best Regards,
Community Support Team _ Ailsa Tao

[Dharma0208]

Hi @v-yetao1-msft 

Like  I need to sort the 100% stacked column chart based on values but not on legend based. So can you guide any way . As you can see here based legend order bar is showing. As we can't do this in bar chart i need work around solution.

And for this query(there's a way to put the the the larger number at the end and grow the stacked till the lowest?)

-->there's a way to put the the the larger number at the end and grow the stacked till the lowest? In the image is working cause a I put some space/tab into the name of legend.