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.
Hello,
I have a data set where I have duration in seconds, which I'm looking to convert to a format to show days, hours, minutes and seconds. Once converted, I'm then hoping it's possible to put the information on a graph where I can show average duration on the y-axis and the month on the x-axis based on my other column called Closed Date.
I could not figure out how to use query editor to convert the duration from seconds to the format I am requiring. I've also never seen graphs in Power BI where the y-axis is time.
Below is a sample excel of my data and a pbix
Any help would be really appreciated.
Solved! Go to Solution.
What if you generate these columns:
DAYS = TRUNC([Business Duration]/86400)
I had this issue and I found out that Power BI doesn't support showing Y Axis duration data as time in that DD:HH:MM:SS format. I had a data set that calculates an average duration in minutes, and I made a line graph to show that average duration vs day. I created measures:
Line chart attached showing tooltip.
@Anonymous
Thank you for responding and providing some insight into your data. It's too bad it cannot graph the data as required.
I'm in need to graph the average duration (once converted to dd:hh:mm:ss) monthly to show the trend that is occurring.
Have you had to do similar reporting over that time instead of looking at it vs day?
What if you generate these columns:
DAYS = TRUNC([Business Duration]/86400)
@Anonymous
This is great, I'll be able to work with this. Appreciate you helping me out!
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |