Sort Stacked Area Chart by Measure Values

[mnhamermesh]

I'm trying to sort a stacked area chart by the field included in the "Values" field.  I've seen posts where people create sort tables with unique values for each item, but I want the sort order to dynamically change with the summarized values being shown on the chart so when a user makes a slicer selection the legend / stacked chart automatically re-sorts to show the highest summarized value on the top of the legend.

 

I've tried to sort the Legend field by the column included in the values field, but then run into the 'Sort by another column error'. 

I've seen others create a new table using the DAX Summarize function which mimics a SQL query with fields + summarizations + group by clause, but trying this method I still couldn't get around the sort by another column error.

Any help is greatly appreciated!

[amitchandak]

@mnhamermesh , Ideally base column and sort should have one- to - one mapping, that will be best. See like that is not the case, there is two sort value for one value.

refer I explained that in the video -  How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[mnhamermesh]

Hi,
Thanks for the response, I watched the video but it doesn't solve for my use case.  I tried to add a rankx column to my table but get an error that I cannot compare text values with number.  I need to sort a text column by the summarized values from a number field dynamicallly so not sure a static rank works in this case. This task is super easy to accomplish in Tabelau, suprised it seems so difficult in PBI.