Order Stacked Bar Values by High and Low

[galavichid]

Hi,

I have in my dashboard 5 '100% Stacked bar charts' which I present in each of them 1 table "fruits" contains 5 different kind of fruits.

Each bar showing the amount of each fruit collected in kind of site (we have sites named c1, d, a etc)

I would like the bar to order from right to left which fuirts collected the most to the smallest one.

Is that possible?

For ex. site A will show from right to left: bright grey-dark grey-red

Thanks

[v-yangliu-msft]

Hi  @galavichid ,

Are you referring to the way the bars are sorted by fruit value from largest to smallest?

You can click on the ellipsis - Sort Axis - Sum of Values - Descending Order

If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[galavichid]

its not existing with the stacked bar: