Sort Legend Dynamically By field parameter

Hi, ChristianCaz 

If you want to customize the sort order of the legend, then you can create a calculated column and use this column to sort. Here's a reference:

I have the following chart, the default sort is A, B, C:

I created a calculated column with a custom order using the following DAX:

sort column = SWITCH('Table'[Type],
    "A",3,
    "B",1,
    "C",2
)

I copied the Type column with the following DAX:

Sort the Type copy columns according to the following image:

Put the Type copy column in the legend of the chart:

You can use your rank column to sort your legend columns. Keep in mind, however, that a legend corresponds to a unique ranking. In my example, I have two rows Type=A, both of which rank 3.

If there are two different rankings corresponding to legend A, an error will be reported.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.