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 am trying to calculate the time difference between the max time and min time of the entries in an ID.
How do I change the column in the visual so that the date doesnt display, only the time?
e.g. the second row, third column, would just say 08:37:00
Thanks in advance for the help
Solved! Go to Solution.
One way is go to edit query select column and right click on it.
Edit query -->Select datetime column --> Right click --> select transform --> select Time Only
One way is go to edit query select column and right click on it.
Edit query -->Select datetime column --> Right click --> select transform --> select Time Only
Hi @NNaj ,
It's possible in PBI to use custom format strings for columns or measures on the modeling view check the documentation if you are using a column or a measure and don't want to change the format becayse you can use it in other visual in a different way you can create an additional measure or column with the FORMAT sintax something similar to this:
Hour Format = FORMAT(Table[Column]; "hh:mm:ss")
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |