How to list percentages in order?

[abeiswinger]

When I display data with percentages (i.e. Ratings for Inspections), the "100%" value is showing at the top of the list, because it starts with 1, rather than showing at the bottom after 90%.  Is there a different way to group the data so that it shows correctly?

[v-sihou-msft]

@abeiswinger

In this scenario, please add a numeric column and give a number for each bucket for sorting. Then sort the Bucket column by this column. Otherwise it will always sort the Buckets in alphabet order so that it starts with 100%

Regards,

[abeiswinger]

@v-sihou-msft

I'm not sure what you mean, sorry.  Can you clarify?  I have created a column in my datasource and called anything that was 100% "A" and 90-99% "B" and so on, but that didn't work.  Also tried naming them as "1", "2", etc... but the visual still sorts by what the Group names are.