Forum Discussion
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...
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
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
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
