Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to sort a stacked area plot by area size

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!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , 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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    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.