Percentages truncated on export

[davinci_cat]

I have a problem trying to export data from Power BI into Excel where the original values are like 4.547132009% but all I get in Excell is 4.500000000% and this creates a problem where the column of percentages doesn't add up to 100% anymore. Are there any ways to work around this issue please?  TIA.

I have tried both showing data in Power BI as % of column total and I also created a measure to calculate the column total; the end result is the same.

[Anonymous]

Hi @davinci_cat 
check below steps

The issue you're experiencing where the percentages are truncated when exporting data from Power BI to Excel is likely due to the formatting settings in Excel. By default, Excel may round the displayed percentages for simplicity. To work around this issue and ensure the exported percentages retain their precision, you can follow these steps:

Method 1: Format the Column in Excel

1. After exporting your data to Excel, select the column with the percentages.

2. Right-click on the selected column and choose "Format Cells."

3. In the "Format Cells" dialog box, go to the "Number" tab.

4. In the "Category" list on the left, select "Percentage."

5. Adjust the number of decimal places to the desired precision (e.g., 9 decimal places).

6. Click "OK" to apply the formatting.

This will display the percentages in Excel with the desired precision.

Method 2: Use Power Query to Export Data

1. In Power BI, you can use Power Query to export the data to Excel while specifying the desired data type for the percentage column.

2. Load your data into Power Query by clicking "Edit Queries" in Power BI.

3. In Power Query, select the percentage column, and in the "Transform" tab, change the data type to "Decimal Number" with the desired number of decimal places.

4. After making this change, close and apply the changes in Power Query.

5. Now, when you export this data to Excel, it should maintain the desired precision for percentages.