Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 this to excel I get the following corresponding values:
The hash values reprents a number between -1 and 0, and excel can't interpret them as time due to the negative sign. If I change the sign or add +1 one the "Inicio"-column value I get:
+1 gives the correct time value. There is a formatting issue between report builder and excel I can't seem to figure out. I found a post where someone said to enable the "Use 1904 date system" under excel options. If I do that I get the following:
The dates are changed and the times are "mirrored". It is important for my delivery that the format is correct without manually fixing cells in the excel after each export.
Anyone tips on how to fix this? Thanks!
Solved! Go to Solution.
@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
@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
=Format(Fields!Time_From.Value,"HH:mm:ss")
Worked like a charm! Thanks @amitchandak 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |