Forum Discussion
Advocate ISuper Stupid: How do you sort Visual Legend by Value?
Solution SageAlternative solution I just got working, based loosely on this approach:
https://www.seerinteractive.com/insights/reorder-powerbi-legend
I created a new table using :
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:
Then I selected the [group] column and used the "Sort by Column" option under "Column Tools" and selected [custom sort].
Advocate IThanks 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?
- kpost
What is the name of the visual you are using? It doesn't appear to be behaving the way the ones that come standard with the desktop software do... I'll download it and see if I can get it to work.
- crwinchester
kpost : Here is the one I'm using: https://appsource.microsoft.com/en-us/product/PowerBIVisuals/WA104380759
- crwinchester
kpost , were you able to try the AsterPlot visual I mentioned above? I stil haven't found a way to get it to obey any sorting rules. It still seems broken. Thanks.
- crwinchester
There seem to be a number of visuals with this problem. It still feels like PowerBI is the foundational issue: Inherint sorting via the loaded data should be a standard option.