Forum Discussion
Sort Stacked Area Chart by Measure Values
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 dy...
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
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.