Forum Discussion

cuohanele's avatar
cuohanele
Icon for Helper I rankHelper I
6 years ago
Solved

DYNAMIC SORTING

Hi everyone! In need of some assistance. I created a dynamic format for a column in my table to be filtered by a specific slicer. Unfortunately, it is sorting the numbers like they are string. I u...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi cuohanele ，

     

    Using "format" function is to change the number into text format,so go to "column tools " in the menu bar to set the number into "percent" format.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

They are strings. The FORMAT() function  converts values to text. You'd need to have leading zeros to format correctly. I am not aware of a way to conditionally format numbers by number format (currency, percentage, etc.)