Forum Discussion
Sorting Funnel chart by a job grade
Resident RockstarHi paulotv，
Have you tried with the feature Sort by column?
Besides, if you want to show gender, you may could try with the custom visual Tornado chart which have the legend field.
If you need further help, please some data sample or your expected output.
Best Rgards,
Cherry
Hi v-piga-msftthanks for both your suggestions. The funnel chart is excellent. I hadn't noticed the sort function before.
When I use the sort function it doesn't seem to work as intended. The job grade I want to sort in are a mixture of numeric and alphabetic grades. So the field format is text. I prefixed each grade with a letter of the alphabet. So the most senior grade starts with 'a' and the most junior grade is the last letter in the alphabet needed in this case 'p'. When I sort on the field it arranges the data k,i,m,h etc not a,b,c,d, etc
Basically, I'd like to sort alphabettically on the Group and not by the size of the Group.
Is there a way I cna fix this?
Cheers
Paul