Forum Discussion
Solved
Time Duration and Time Graph Plotting
Hello Everyone, I am new to Power BI. Looking for some help. Earlier I use Excel and Power Point to present Weekly Report. Now i have started in Power BI. I use to compare average resolve time we...
Hi Avichal ,
You can try this:
1. Duplicate column of ‘Duration’.
2. Split ‘Duration – Copy’ with ‘:’.
3. Add a custom column.
=[#"Duration - Copy.1"]*3600+[#"Duration - Copy.2"]*60+[#"Duration - Copy.3"]
4. Remove columns.
5. Create a line chart, put ‘Seconds’ in ‘Values’ and ‘Duration’ in ‘Tooltips’.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
I have the same problem: anyone can help please?