remove decimals

[lastnn30]

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 that possible? Thank you very much.

[VijayP · Accepted solution]

@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 · Accepted solution]

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

[VijayP · Accepted solution]

@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

[simonet]

Is there an updated version of this answer. In my current PowerBI instance, there isn't a display units or a value decimal places dropdown