How to sort by amount in clustered column chart

[Anonymous]

Hi all,

How to sort Final Amount in descending order?

Already try a few step but nothing happen.

Regards,

Nuha

[amitchandak]

@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]

Hi @amitchandak ,

So you are saying it impossible to sort by amount?

Regards,

Nuha

[v-jingzhang]

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!