FORMAT function not working for decimal to percentage conversion

[Anonymous]

Hi All,

I have a measure called #DaysElapsed, with following formula

 I am displaying this measure in a table visual. It is working as expected and giving me a decimal which I am displaying as percentage using the formstting options and then publishing the report in PowerBI Service.

The value is displayed as a percent. 

But when downloading (exporting data from table visual), this value is shown as decimals in exported excel.

When I am trying to use FORMAT function as 

 the data is getting duplicated and the value is coming blank in the entire table visual.

Please suggest how to resolve this

[V-lianl-msft]

Hi @Anonymous ,

Please try what @PC2790  said, it works well for me.

Use the date format instead of the date hierarchy. The value will not be empty.

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

[PC2790 · Accepted solution]

Hello ,

Can you try the below once:

#DaysElapsedPcnt = FORMAT(DATEDIFF(SELECTEDVALUE('B2R Active Offers'[Offer Start Date]),TODAY(),DAY)/90,"0.0%")

[Anonymous]

Hello,

Thanks for the support !!!!
I have tried this as well, but this is also not working.

Regards

[amitchandak]

@Anonymous , Check the format here

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

Also in measure tools, you have the option to mark it as %

https://stackoverflow.com/questions/38353064/how-to-format-new-measure-not-column-in-power-bi-as-percentage

[Anonymous]

Hello,

Thansk for the support!!!

I have tried formatting it using the modelling tab. That way, display in table visual is workinf fine. However, when exporting data from table visual on PowerBI service, the formatting seems to be dropping, as it is then showing decimals (and not percentage) in downloaded data.

Regards