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.
I have a column that is a duration in a time format, yet when I add to a table it shows as a decimal. For example, when looking in the query, the following value:
0.03:23:02.4000000 |
Is displayed as: 3.38 ... I would like it displayed as 3:23 ... any help? Thanks!
Solved! Go to Solution.
Hi @cumoczar ,
Duration represents a length of time. It’s converted into a Decimal Number Type when loaded into the model. It is as designed according to this document.
If you only want to show duration of time in a Table report, I think the easiest way is to change the Data Type from “Duration” to “Text” as below. Then it will keep the type as "Text" and can be showed correctly.
Hi @cumoczar ,
Duration represents a length of time. It’s converted into a Decimal Number Type when loaded into the model. It is as designed according to this document.
If you only want to show duration of time in a Table report, I think the easiest way is to change the Data Type from “Duration” to “Text” as below. Then it will keep the type as "Text" and can be showed correctly.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |