sorting in slicers

[rtgjeg]

I've been using slicers for some time, but I've never come across this issue. I imported allot of data (over 3 million rows) using the data model in Power Pivot. Each row in the data model contains a column with percentages, and I can't seem to sort it properly. This is what I get:

0% 1% 10% 100% 11% 12% 13% 14%

 

[crazydragon84]

does it think its a text instead of a number