Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Proud to be a Super User!
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
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |