Table Sorter visual | values with only 2 decimal places

[sofias]

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.

[v-yulgu-msft]

Hi @sofias,

You could refer to below screenshot.

Best regards,

Yuliana Gu

[sofias]

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]

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

[Thejeswar]

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'