How to sort a stacked area plot by area size

[D_kim]

Hi power bi experts and fans! Does any of you happen to know how to order stacked column or area charts by size of their value? So in the example attached, Azure item (USA) at bottom, followed by blue, yellow, etc.

Of course the order of the different categories changes over x-axis. But it would be ok to choose the order on 1 fixed moment in time

Thank you in advance!

[v-henryk-mstf]

Hi @D_kim ,

Based on your description, there seems to be a similar solution as follows. See if it helps you.

Solved: Clustered bar chart, clustered in order of size - Microsoft Power BI Community

If not, please point out. Or provide the relevant data model (delete sensitive information), I will do further testing for you.

Best Regards,
Henry

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

[amitchandak]

@D_kim , Not very clear can you explain with example?

But both axis and legend order can be changed with the sort column.

Axis sort can also be changed using three dots

refer if needed

How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c