Power BI to excel export

[Anonymous]

Hi Team,

I have a  dashboard in Power BI Service. We use Oracle as a source. In my matrix visual , I have two measures, one is period TY and its respective percentage % .  Before publishing to power BI service,  I have rounded Off the % decimals to two , Which means the value will appear as 9.78%, 8.23 %etc., 

Now, after publishing, I tried exporting the matrix visual to excel. After doing that, I am seeing my percentage % values as 9.7832, 8.23456 etc., without the % symbol and without the round off condition. 

Need your help to get rid of this extra decimals in excel. Even its strange, why in excel it is showing like that, as we have rounded off the decimals in power bi.

Please advise!

Thank You

[ibarrau]

Hi. How are you exporting and how are you rounding? I have opened a desktop, created a measure that returns a lot of decimals. Then I selected the measure and went to the menu to change it for Percentage or Decimal and hardcoded 2 decimals. I have exported from the matrix visual as .csv.

The csv looks fine. Only two decimals for the measure.

I hope that helps,

[Anonymous]

Hi,

Please see, this 

From the above image, which is in power BI service, all the values are showing in percentages with 2 decimals.  Now , when I tried exporting to excel from the published app, I was getting as below

Why I am not getting the % values in % only when I export to excel? Why is it coming in decimals?

Please help!

[ibarrau]

That's so weird. I have just tried again. I have exported data from a Report owner of the Dataset as xlsx with the option "Data with current layout" and it worked perfectly.

How are you formatting the value? For me it's working the measure and the format property like this:

Be sure you have it like this. If not change it, publish and try again. It should return corretly :S

I hope that helps,