Stacked column chart: Sort legend by value, not alphabet

[sash]

Hi,

Is there any way of configuring the stacked column chart to sort the stacked groups by value and not by alphabet? 

I've found a similar question and a solution here (using the group names and prefixing them; like 1_name, 2_name, etc.): https://community.powerbi.com/t5/Desktop/Modify-the-legend-order/td-p/25337. However, in my case I don't want to define the order myself, I want it to be dynamically sorted based on the value of the measure (highest value on the top). 

Here is an example of what I want to achieve:

[v-sihou-msft · Accepted solution]

@sash

If you have only one category on X-axis, you can have your Legend column sort by Value column.

If you have multiple catgories on X-axis, this method will not work. You have to manually define the order column in your table. 

Regards,

[cjdw_PU]

On multiple categories x-axis, while preserving the x-axis sort order, I would like to sort the stacked column by value, not alphabet. And doing this dynamically. Any pointer on what calculated column / measure / DAX to do this, rather than manually define the sort order for each x-axis category?

[divyesh_143]

Welcome to the world of Power BI!