Forum Discussion
Solved
Sort legend
How can i do a manual sort on the legend in a graph visual? Because i use numeric description in the text it sorts as alphas rather than numeric: I want it sorted in time order: Early ...
I assume the "bucket" column you put in Legend should be based on another numeric column. You can't directly have this "Bucket" column sort by that numeric column.
In this scenario, you can create another sort table like:
Bucket Order Early 1 On time 2 5 - 10 days 3 11 - 15 days 4 16+ days 5 Then build the relationship to your existing table on Bucket column, and use "merge queries" to join the Order column into existing Query. Now you should be able to have the Bucket column sort by Order column.
Regards,
