Forum Discussion

ChristianCaz's avatar
ChristianCaz
New Member
2 years ago
Solved

Sort Legend Dynamically By field parameter

Hi everyone,

 

I have a stacked graph and it is made by a field parameter, however, I can't get the legend to be completely ordered by the rank, do you know how can I sort the legend of the graph?

 

Thank you!!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

2 Replies

  • Doccrs's avatar
    Doccrs
    Regular Visitor
    10 months ago

    I know this question is a year old now. But the accepted solution is NOT a solution.

    The OP ask how they do this on a Field Parameter (FP) - the solution given does not work when using a field parameter. You cannot use calc columns in a legend where an FP has been used on the Y-Axis. As of Oct-2025 there is still no solution to this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.