Forum Discussion
bjorneev
Advocate I
Advocate IPagniated Report Excel Export formatting problem
Hi all, I have created a report in Power BI report builder that contains some date and time information. The first rows of the table looks like this when I run the report: When I export th...
bjorneev , This just one idea, may not be ideal
Format time = format([Start Time],"HH:MM:SS")
This will make it text and will not change format
amitchandak
Super User
Super Userbjorneev , This just one idea, may not be ideal
Format time = format([Start Time],"HH:MM:SS")
This will make it text and will not change format
bjorneevAdvocate I
Advocate I=Format(Fields!Time_From.Value,"HH:mm:ss")
Worked like a charm! Thanks amitchandak 🙂