Forum Discussion

micpete's avatar
micpete
Helper III
1 year ago

Exporting custom formats with current layout

Hello,   Whenever I export data with the current layout to excel, any custom format for example I have a custom format for time 00:00:00 - on the excel exported it does not include my custom format...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi micpete 

 

In my test, this feature works well:

 

In Excel:

 

 

And here are some steps for your reference:

Make sure your time data in Power BI is correctly recognized as `Date/Time`. Sometimes, this alone can solve formatting issues.

If all else fails, you can apply the custom format manually in Excel after exporting. Select the time column, right-click, choose **Format Cells**, and set the custom format to 'HH:mm:ss'.

Just as rajendraongole1 posted that you can create a new calculated column in Power BI that formats your time as text. This can help in preserving the format when exported.

FormattedTime = FORMAT([YourTimeColumn], "HH:mm:ss")

 

Hope these steps can help mitigate the issue.

 

Best Regards

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