Forum Discussion

crwinchester's avatar
crwinchester
Icon for Advocate I rankAdvocate I
3 years ago

Super Stupid: How do you sort Visual Legend by Value?

I see there a number of questions about this, but the answers are disturbingly complex - Where is the button that I click to have a legend sort by value? I've already sorted all the underlying data i...
Need Help
kpost's avatar
kpost
Icon for Solution Sage rankSolution Sage
3 years ago

Alternative solution I just got working, based loosely on this approach:
https://www.seerinteractive.com/insights/reorder-powerbi-legend

I created a new table using :

sort_table = generateseries(1,1000,1)

I then made a relationship between that column and the [group] column.


then I added this column to the same table where the [group] column is located:

custom sort = RELATED(Sort_table[Value])


Then I selected the [group] column and used the "Sort by Column" option under "Column Tools" and selected [custom sort].

  • crwinchester's avatar
    crwinchester
    Icon for Advocate I rankAdvocate I
    3 years ago

    Thanks for this response. I followed these instructions and there was no effect. I created a new table by entering data. I then established the cardinality, created a column with the related function, and finally told the visual to sort the data by that column. PowerBI still disobeys the sorting logic. I think there may be a glitch. Sorting the data with inherint sorting qualities should sort automatically OOTB. Unless there is another method I'm missing?