Forum Discussion
Exporting custom formats with current layout
Hi micpete - This issue arises because Power BI exports are limited in how they transfer formatting to Excel, particularly with custom formats in "Current Layout."
You mentioned that exporting in "Summarized Layout" preserves the format. If your data needs and formatting requirements allow, this may be the simplest solution, as Power BI better preserves custom formatting in this layout.
Although not ideal, you could create an Excel macro or use conditional formatting rules to reapply the custom format upon opening the export file. If this is a repeated task, automating it within Excel might save time.
TimeFormatted = FORMAT('Table'[TimeColumn], "HH:MM:SS")
This way, the custom format is saved as text, which might carry over better during export. However, this method will treat the values as text, not numbers or time, in Excel.
Ideas - Microsoft Fabric Community
if it not works, raise it as an idea by using the above link
Hi all,
I should have mentioned that I'm using a measure for calulating total time, I've had to convert time to seconds then a calcuation to sum each hour, minute, second total, so I don't have the option to change the data type to time as the value presented looks like a time value, example return output could be 2160800 which I've then used the custom format option in power bi to ":" to separate the value into hours, mins, seconds so that it looks like 216:08:00. I've tried using TimeFormatted = FORMAT('Table'[TimeColumn], "HH:MM:SS") as you mentioned in your post but I get an error message.
Hi micpete
I did the same thing as you, but it works well too.
If possible, could you please share some raw data(exclude sensitive data) or create some sample data. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
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.
