Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Need to sort legend in 100% stacked column chart

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?

Dharma0208_0-1675925410147.png

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

Status: Needs Info

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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
New Member

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.

 

Dharma0208_0-1676004761895.png

 

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.

 

Dharma0208_1-1676004962040.png