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

 

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

3 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    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

     

    • simonet's avatar
      simonet
      New Member
      1 year ago

      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

       

       

  • 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