Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to sort by amount in clustered column chart

Hi all,

 

How to sort Final Amount in descending order?

Already try a few step but nothing happen.

 

 

 

Regards,

Nuha

 

General Comment
Need Help
Show and Tell

3 Replies

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

    Anonymous , Once you use legend, power bi sort the legend internally on legend value(Asc/Desc options are there). As you have data for only one axis value. you are seeing it is sorted on legend value.

    I doubt as of now you can sort legends on values.

     

    You can log an idea- https://ideas.powerbi.com/ideas/

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi amitchandak ,

       

      So you are saying it impossible to sort by amount?

       

      Regards,

      Nuha

      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi Anonymous 

         

        I did a test as below. When a clustered column chart has Legend field, sorting axis by Y-axis value ascendingly or descendingly is based on the total Y value of all legend items for each x-axis value. 

         

        It is not possible to sort the legend items by Y-axis value within each x-axis value. 

         

        Best Regards,
        Community Support Team _ Jing
        If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!