Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
3 years ago
Solved

remove decimals

Hi I have the table below, I select "show values as %" and now I see all these values in percentages. I wonder if I want to get ride of these decimals for example   70.32 %   to 70%  or 71%   Is...
Need Help
  • VijayP's avatar
    VijayP
    3 years ago

    lastnn30 

    Select the foramt options and go to Specific Columns there you will find decimal options. and you can change the decimals to 0. as showin in picture

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi lastnn30 ,

    There is no direct option to set the decimal places, you can follow the steps below to get it. Please find the details in the attachment.

    1. Create a measure as below to get the percentage

    % Total = 
VAR _pertotal =
    SUM ( 'SalesTable'[Total] )
VAR _alltotals =
    CALCULATE ( SUM ( 'SalesTable'[Total] ), ALLSELECTED ( 'SalesTable' ) )
RETURN
    DIVIDE ( _pertotal, _alltotals )

    2. Set the data type format of measure as Percentage and decimal places as 0

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi lastnn30 ,

There is no direct option to set the decimal places, you can follow the steps below to get it. Please find the details in the attachment.

1. Create a measure as below to get the percentage

% Total = 
VAR _pertotal =
    SUM ( 'SalesTable'[Total] )
VAR _alltotals =
    CALCULATE ( SUM ( 'SalesTable'[Total] ), ALLSELECTED ( 'SalesTable' ) )
RETURN
    DIVIDE ( _pertotal, _alltotals )

2. Set the data type format of measure as Percentage and decimal places as 0

Best Regards