Forum Discussion

sofias's avatar
sofias
Frequent Visitor
8 years ago

Table Sorter visual | values with only 2 decimal places

Hello everyone,

 

Can anyone please help me to understand if it is possible to only have values with "X" numbers of decimal places? In my case, I want 2, and I'm using Table sorter visual. And I only cannot do it to the value that I use as "rank" value.

 

Thanks.

 

Need Help

4 Replies

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    8 years ago

    Hi sofias,

    Did you try doing the following

     

    1. Select the column in the Fields section,

    2. Go to the Modelling Tab in the Ribbon

    3. Change the Data Type  as Decimal Number and set the Number of Decimal places to 2. It will be by default 'Auto'

    • sofias's avatar
      sofias
      Frequent Visitor
      8 years ago

      Hello,

       

      Yes, that is my default definition but it still wont work. What I did in the meanwhile was to have that metric calculated with a round function, with 2 decimal places. But still don't know how to do it in the visual or even if it is possible.

       

      Thank you

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi sofias,

         

        Based on my test, it is not possible to set the decimal places for the field added to Table Sorter. As of now, the best choice is to do metric calculated with a round function, as you mentioned above.

         

        Regards,

        Yuliana Gu