round off in power bi not the same in excel

[tebtim19]

I've noticed that the rounding off in Excel is not the same in rounding off in Power BI. Any fix for that? for example in  excel when you devide 7.49/68 it goes to 11.01%, but in power BI it shows 11.09%

[v-yangliu-msft]

Hi  @tebtim19 ,

The display in power bi is also 11.01%:

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tebtim19 , Just make sure division and data type are correct. I doubt this much of diff can come.

I check result is same till 4 decimal place too